| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 264.1 | Some things are better done by hand | FEISTY::TILLERY | | Fri Sep 01 1989 07:46 | 5 |
| Read all the SLSREP's into a hold file, sorting on Badge. After
Focus has stored the data, edit the hold files .MAS to change it
to A6 form the I6. Should work.
Jim
|
| 264.2 | Still confused | OURBOX::LAZARUS | Dave Lazarus NYA DSS 321-5183 | Thu Sep 07 1989 12:12 | 7 |
| Jim,
Thanks for your reply. I tried what you said ,but when I tried to
print badge I got garbage. I must be doing something wrong.
David Lazarus
|
| 264.3 | Me too | FEISTY::TILLERY | | Fri Sep 08 1989 07:57 | 12 |
| Hi Dave,
Have you typed out the hold file just to look at the data. It sounds
like you have the field expanded bigger than it was intended and
are grabbing junk. If the data looks all right in the hold file,
play with it, or look at the other file which you are joining it
to. Is that where the junk is?...
Hope this helps,
Jim
|
| 264.4 | Anybody know FOC1006? | OURBOX::LAZARUS | Dave Lazarus NYA DSS 321-5183 | Wed Sep 27 1989 00:29 | 15 |
| re .1 -- Although I hated the idea of loading 35,000 salesman each
time,I decided to use the SLSREP record,join it with AM03 and create
a small file. That worked fine,but when I tried running the Fex
I got the following error:(FOC1006) DDNAME is not allocated
My feeling is that you can't join a file created during the run
process. The Focus Help Line disagreed with me and even gave me
an example to show that it should work. They say something is
set up wrong on our system.
1) Has anyone seen FOC1006 ?
2) Because of its size and context,I defer putting it in this reply,but
if any of you Focus experts would like to try to help me,I can mail
it to you.
|
| 264.5 | comment on .1 and .4 | MILPND::MADDEN | | Wed Sep 27 1989 08:36 | 11 |
| Re .1 creating a hold file from the SLSREP should work, but you have
to SET HOLD = ALPHA so the integer field badge will be stored as an
alpha-numeric instead of a binary integer. This is probably why it
didn't work. Another hold file technique would be to define an alpha
badge field - ASLSREP/A6=EDIT(SLSREP); and table the define field into
the hold file instead of the database field (SLSREP).
Regarding creating a file and joining to it in the same .fex, I agree
with IBI that if the -RUN statements and FILEDEF statements are
properly placed this shouldn't be a problem. If you give some general
code examples, I could comment further.
|
| 264.6 | The solution was too many uses | BROOKE::LAZARUSD | David Lazarus NYA-DSS 321-5183 | Wed Sep 27 1989 13:42 | 30 |
| Re -1 > Creating a hold file from the SLSREP should work, but you have
>to SET HOLD = ALPHA so the integer field badge will be stored as an
>alpha-numeric instead of a binary integer. This is probably why it
>didn't work.
It does,see below.
> Another hold file technique would be to define an alpha
> badge field - ASLSREP/A6=EDIT(SLSREP); and table the define field into
> the hold file instead of the database field (SLSREP).
I am doing that.
I finally was able to fix the problem,and hopefully it will be helpful
to anyone encountering this.
I decided upon the solution of joining SLSREP and AM03 to create
a small file of sales badge numbers equal to New York area. I edited
the badge to be alpha. Simple enough.
So I thought the (FOC1006) error had to be a FOCUS problem related
to joining a runtime created file. The hot line assured me that it was not
a problem for Focus to do that and showed me an example of that
being done. So our problem had to be somewhere else.
It turned out that we went beyond the Use limit of 50. So I
do a USE CLEAR and just describe the files I need.
BTW,IBI says the joining of different data types(what caused the
entire problem) is an enhancement in 6.0 due in Feb 1990.
David Lazarus
|