Mike, I'm getting the ascii file from the following command:
Unload data for my_table using my_field as ascii where my_other_field = whatever How can I construct this to equal variables? > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB > Sent: Friday, September 09, 2005 2:27 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Variable from the contents of an ascii file > > when you write the values to the ascii file, construct code on the fly > that > will set the values to variables as you want like: > > out test.asc > write 'Set var v1 int = 53' > write 'set var v2 text = ''SomeText''' -- single quotes > write 'Return' > out scr > run test.asc > > > > This is displayed this way for simplicity. You can construct the values > for > the write statements in code as variables and then write that to the file > as > well... > > > ----- Original Message ----- > From: "Claudine Robbins" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Friday, September 09, 2005 2:16 PM > Subject: [RBG7-L] - Variable from the contents of an ascii file > > > > > > Hi everyone, > > > > I want to create a variable which will contain one or more values > extracted > > from a table, i.e.: 53, 45, 101. > > > > So far, I can create an ascii file, test.asc with "53","45","101" if I > first > > reset the quotes to ". > > > > Now, I want to put these values in a variable. I can't figure out what > to > > do next. > > > > TIA, > > > > Claudine :) > > > > --- RBG7-L > > ================================================ > > TO POST A MESSAGE TO ALL MEMBERS: > > Send a plain text email to [email protected] > > > > (Don't use any of these words as your Subject: > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: INTRO > > ================================================ > > TO UNSUBSCRIBE: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > ================================================ > > TO SEARCH ARCHIVES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: SEARCH-n > > (where n is the number of days). In the message body, > > place any > > text to search for. > > ================================================ > >
