[U2] select query..

CAPTURING junk Here Im running a loop for a set of KEYVALUEs and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks Regards, Sathya V

Re: [U2] select query..

? I will modify it with using LIST1 directly. Thanks Regards, Sathya V. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH at ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1

Re: [U2] select query..

Mecki Foerthmann meckif at gmx.net writes: ___ U2-Users mailing list U2-Users at listserver.u2ug.org Actually Im fetching the KEYVALUE data from a flat file and passing the values one by one to the select command and creating the list. Then

[U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.

DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, Sathya V. ___ U2-Users mailing list U2

Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.

and not the Unidata file. Can you please let me know how to do it? as Im facing issues with opening the file. Thanks Regards, Sathya V. On 7 May 2013 16:37, Sathya sathya83aa at gmail.com wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me

Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.

need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Help needed..

recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V

[U2] Help needed..

corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users

[U2] List..

Hi all,.. I have a small issue in listing a file. When I use LIST FILENAME, the data comes like 123456*001 123456*001. I would like to display the data as 123456 123456 Can someone please help me in doing this? TIA, Sathya V. ___ U2-Users

[U2] Date conversion..

Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V

[U2] History..

:-( TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users