Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this – could you please let me know. Alternatively is there is another better utility for copying Database file to [...]
Answer Question | May 27, 2012 9:37 AM
We are using IBM tape library TS3100. In past 2 days, when backup started the tape was automatically came out to IO station. The backup was in MSGW state and was asking for media. When I inserted the tape again and replied with G, the backup was started as usual. Does anyone know why it [...]
Answer Question | April 3, 2012 5:36 AM
AS/400 BRMS, IBM Tape Libraries
hi, how to upload the data into bpcs files from excel sheet. please anyone help on this.
Answer Question | April 17, 2012 5:24 AM
hi friends… I am using load all subfile…in that first it will display all records.what my question is when i give any condition it has to display empty subfile ie.only subfile record format?? plz guide me as early as possible..
Answer Question | April 9, 2012 7:03 AM
AS/400, AS/400 Subfiles
Hi How do you display all objects with publich authority? Thank you
Answer Question | April 2, 2012 2:21 AM
iSeries, iSeries data center, iSeries RPG programming
I want to print them or save them in a spreadsheet. No, I don’t have BRMS.
Answer Question | April 1, 2012 6:24 AM
IBM iSeries, Operations Navigator
I am given a http:// address and would like to send file to that address from the AS400. Was told I can use SFTP. What is the syntax.
Answer Question | April 1, 2012 5:05 PM
What is wrong in the *BLANKS in the following code WHERE (EMPID=:*BLANKS OR EMPID=:EMPID)
Answer Question | March 30, 2012 9:43 AM
AS/400, AS/400 SQL
How can I stop the STRPCCMD from leaving the pop-up window open? I’m using the PAUSE(*NO) parm in my CL program and it still leaves the pop-up on the screen.
Answer Question | April 3, 2012 6:27 PM
iSeries V6R1, STRPCCMD
I am able generate a report using printer file.Now the concern is how to make second or more page when the records are too many.
Answer Question | March 30, 2012 7:32 AM
AS/400, AS/400 Printer File
There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this id on daily basis to [...]
Answer Question | March 31, 2012 6:45 AM
iSeries DB2, SQL statements
Hi I need to Run a Job daily at 11Am Except Saturday & Sunday. How I can do it. And also What is the Use of WRKJOBSCDE and ADDJOBSCDE. Lib1/Prog1 user-user1
Answer Question | March 29, 2012 6:19 AM
ADDJOBSCDE, AS/400, WRKJOBSCDE
Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with Zeroes. [...]
Answer Question | May 22, 2012 3:50 PM
as400/DB2, SQL/400, SQLRPGLE
Is there application which convert RTF documents to PDF and is running on i5. RTF files are on IFS folder and there is thousands of files to convert.
Answer Question | May 3, 2012 6:28 AM
AS/400, i5/0S, iSeries applications
Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below. Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below. C/EXEC SQL C+Insert into [...]
Answer Question | March 26, 2012 7:52 PM
Hi all ! this works – SBMJOB CMD(QSH CMD(‘/QOpenSys/usr/bin/sftp -v -b + /home/account/sftpcmd.txt + remote_user_account’)) + JOB(SSHJOB) USER(WIRM5501) this does not SBMJOB CMD(QSH CMD( &CMDSHL )) JOB(SSHJOB) USER(WIRM5501) where &CMDSHL is the exact quoted command in the working script I get this error qsh: 001-0014 Command /QOpenSys/usr/bin/sftp -v -b /home/… not found [...]
Answer Question | March 30, 2012 4:13 PM
AS400 iseries, iSeries Commands
Hi Guys, I want to know why it need very long long time to run a select SQL statement on Mimix jornualed files. It ran over 3 days for a select statements on a MimixJrn files (over 1 Millians records). But only use less than 1 hour to complete the same SQL selection statement for [...]
Answer Question | July 9, 2012 2:55 AM
AS/400, MIMIX, SQL statement
Hi Experts, We have just finished relocating our AS400 from one site to another. Hence change of IP was done but setup remains the same machine wise. After which, some FTP and response issues started to arise. My AS400 is a two partition machine running on the same segment as my users and other interfaces. [...]
Answer Question | March 27, 2012 5:53 PM
AS/400 FTP, AS/400 V7R1
Hi, I am declaring a stand alone character field with the length of 6000 in my SQLRPGLE program, but when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field. Could anyone please help me urgently to declare a character field [...]
Answer Question | March 26, 2012 9:30 PM
AS/400, RPG ILE, SQLRPGLE
Hi, New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]
Answer Question | March 23, 2012 9:54 AM
DB2, iSeries, OS/400