Use a cursor and construct it line by line.. ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, September 09, 2005 2:36 PM Subject: [RBG7-L] - Re: Variable from the contents of an ascii file
> 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. >> > ================================================ >> > >
