QEXECSQL command source
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
CSV, OS/400

Backup
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

upload the data into files
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
AS/400, BPCS

Subfile
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

Display all objects with Public Authorities
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

In the IBM i Series (6.1)how can I print the libraries that were selected for backup either from the Operations Navigator or green screen Backup menu?
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

how to do SFTP on AS400 to UNIX given http:// address
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
AS/400, SFTP

SQL/400
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

STRPCCMD leaves pop-up open
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

Printer File
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

Track SQL Statements run by a specific user through ODBC Connection
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

Schedule Job
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

How to acheive FULL OUTER JOIN on three files in IN SQLRPGLE program.
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

Convert RTF to PDF on i5
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

how to write more than one sql statement under EXEC SQL in SQLRPGLE.
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
as400/DB2, SQLRPGLE

batching qsh sftp fails when using a variable for script
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

Long time to run the select SQL statement for Mimix Jornualed file
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

FTP and response issues in AS400
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

Can not able to declare character field with the length of 6000 in SQLRPGLE program.
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

I would like to run a report on AS/400 to indentify which DB2 tables to reorg.
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