How do you do LIMIT in DB2 for iSeries?
We currently have a table of more than 50,000 records and we’re trying to return records of 0 to 10,000 / records of 10,000 to 20,000. We already know that in SQL, if you write “LIMIT 0,10000″ at the end of the query, it will bring you that record. How can you do it in...
| December 11, 2013 9:48 PM
JDE with Robot/Schedule
Hi All, Our new E1 interface to Robot seems to have created an issue where previous EDI react jobs are not finishing in the OS and so Robot Schedule continues to think they are still running. After looking at the job log for the hung job I noticed it only created a data queue in...
| November 20, 2013 4:00 PM
Usage of Binding Directories.
Hi Group, In ILE the complexity of the create program command grows proportionately to the number of modules and service programs that compose the program. In order to avoid this we use Binding directories. Is there any other usage of Binding Directories?? Regards, M
| November 12, 2013 12:42 PM
, ILE RPG
I am not a AS/400 programmer but overheard my colleagues and suggested them to use SSH. Greatly appreciated if anyone can suggest here… They have a batch job which creates a text file containing the sftp command passing IP address, username, password and the file to be transferred. I suggested them to use SSH and...
| November 8, 2013 1:56 PM
PDF send through the mail, cannot be open
I have created a PDF file in IFS folder from PF, using the command CPYTOIMPF FROMFILE(QTEMP/PRT01) TOSTMF(&STMF) + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) + RCDDLM(*CRLF) STRDLM(*NONE) FLDDLM(‘ ‘) ******************** SNDDST TYPE(*DOC) TOINTNET((&EMAIL)) DSTD(&DSTD) + MSG(*NONE) DOC(&DOC) FLR(YSPLF) ********************** PDF send to mail, but I cannot open the file. If I open with the MS...
| October 31, 2013 5:05 AM
, IFS Folder
, PDF Files
How to manage SQL queries on iSeries
We have users who are using SQL to perform queries on our iSeries. As such, we need a way to manage these queries so that, if a runaway, poorly written, etc. causes issues for CPU and/or DASD we can either be notified, end the job, or some other parameter. Is there such an animal? Thanks!
| October 31, 2013 3:16 PM