Re: SELECT into a file

2012-06-25 Thread foxy.md
As far as I know - SAVING clause is used when you want SELECT to return other info than ID. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more

Re: SELECT into a file

2012-06-25 Thread foxy.md
As far as I know - SAVING clause is used when you want SELECT to return other info than ID. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more

Re: jBase 5 / Windows 2008R2 / Logging on process

2012-06-25 Thread Dick Thiot
Simon, One issue that we have found with WinSvr2K8R2 is that when files are copied from an untrusted source they are marked by the O/S as blocked. If you select all of the files in Windows Explorer and look at the properties you will see a Unblock button. There is also a way to unblock all

Re: jBase 5 / Windows 2008R2 / Logging on process

2012-06-25 Thread Daniel Klein
I've got files marked like this but since I have UAC turned off it is not a problem. Dan On Mon, Jun 25, 2012 at 5:43 AM, Simon Verona si...@dmservices.co.ukwrote: Thanks Dick.. That might be it ! I'll check it out Simon === Simon Verona Director

Re: error message: rtld: 0712-001 Symbol STORE_BBS was referenced. help me!!!

2012-06-25 Thread Jim.cnt
Hi, I use your way, the comile comand line is following: jcompile ZFMM/ctest.c ZFMM/simple.c ZFMM/XVCHKXVERIFYPAYPWD.b -d -s ../ xllib/lib1.so when i perform this command line, new error message is thrown as follows ZFMM/ctest.c: ZFMM/simple.c: ../xllib/lib1.so.el: No such file or directory

Re: SELECT into a file

2012-06-25 Thread foxy.md
what I'm trying to avoid is segmentation violation when millions records are returned using EXECUTE SELECT... WITH ... RTNLIST ID.LIST in a routine when I execute ~ --SELECT FBNK.ACCOUNT 1000 records selected is the active select list kept in jbase's memory or is stored in some temporary

Re: error message: rtld: 0712-001 Symbol STORE_BBS was referenced. help me!!!

2012-06-25 Thread Jim.cnt
Hi, I try to comiple ctest.c and simple.c into libCFUNCTIONS.so,I perform the comand line succcessfully as follows, jcompile ctest.c simple.c -d -s libCFUNCTIONS.so And then I compile CHKXVERIFYPAYPWD.b and link libCFUNCTIONS as follows, jcompile XVCHKXVERIFYPAYPWD.b -L. -l CFUNCTION when i

RE: SELECT into a file

2012-06-25 Thread John Fenlon
Guys, The simplest way I have found to do this is using the SQLSELECT. (Use a cmd shell to redirect output). You'll find some environment variables in the SQL documentation that control the outputs in terms of headers, delimiters etc. i.e. CT DICT COMPANY CC 001 A 002 0

Re: SELECT into a file

2012-06-25 Thread Kevin Powick
On Monday, 25 June 2012 09:48:43 UTC-4, Kevin Powick wrote: By using an EXECUTE statement, then processing the resulting list, you're reading every record twice, taking a hit on performance. I should have been clearer with the above statement. Every record in the file isn't read twice.