Breaking a text file on number of pages criteria in IFS.
I have a text file on IFS which has 5500 pages and i want to break it in 1000 pages segments . Please suggest how can i accomplish this task ? Is there any unix or qshell command through which i can do this..

Answer Question   |  September 1, 2012  4:25 PM
AS400 - STRQSH, IFS, Qshell

How to create a AS400 Qshell script (.sh) file
Hi, I want to run a command STRQSH CMD (‘/REPORTGENERATOR/move2current.sh’) Where move2current would be a .sh file with commands as below: rm /HPA_CURRENT/_YOUR_AS400_NAME*.CSV cp /REPORTGENERATOR/*$(date ‘+%Y%m%d’)* /HPA_CURRENT #set new owner chown hpa_transf /HPA_CURRENT/*.CSV My question is how to create this move2current.sh file?

Answer Question   |  March 31, 2012  10:45 AM
AS/400 scripts, AS400 qshell script, Qshell, STRQSH

Select files by wildcard
An old application running S/36e creates workfiles in library QS36F with the following name-structure: ABC.aaXb where ‘aa’ and ‘b’ are random characters, and the ‘X’ is constant. These workfiles are sometimes not  deleted by the application even if they should have been. Once in a while a data-entry program cannot execute since it tries to [...]

Answer Question   |  March 31, 2012  8:07 AM
AS/400, CLP, Qshell, Wildcard

Posts SFTP
When you run the SFTP command from Qshell iseries mode I am presented with the following message: Connecting to 10.100.3.9 … No user can not access! This message occurs with all users but a few. I want to know what caused this message, thanks

Answer Question   |  June 23, 2011  2:14 PM
AS/400 SFTP, OS/400, Qshell, SFTP

qshell job log
Hi When I run any qshell command in my cl program, the job log for qshell gets created in QZSHSH. Is there any way that we can prevent creation of such job logs. Thanks Vivek

Answer Question   |  March 10, 2011  10:38 AM
CL programs, Display Job Log, Qshell

Get File By Date on QSHELL
Hi How can I find out the list of files that were created on the given date. I am trying to use it in a scenario where I need to fetch files through ftp. The folder from which I want to fetch the files will contain many files but I need only the files that [...]

Answer Question   |  March 10, 2011  3:34 PM
FTP, QSH, Qshell, QShell Filename Size

Open URL in RPG from JAVA or QSHELL
how to open web url from a rpg program using QSHELL or JAVA, and without using STRPCCMD, RUNRMTCMD commands as STRPCCMD looses the CLIENT ACCCESS focus?

Answer Question   |  November 10, 2010  4:43 PM
Java, OPEN URL, Qshell, RPG Program, STRPCCMD

Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command
i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

Answer Question   |  July 5, 2011  6:27 AM
DB2, Qshell, QTEMP Library, SQL procedure

Qshell
If i enter a wrong command on the command prompt on QSH screen, how to rollback to the command prompt again?

Answer Question   |  April 5, 2011  11:46 AM
AS/400, AS/400 administration, iSeries Commands, iSeries V6R1, QSH, Qshell

call php script from CL – slow
Hello, i try to call a php-script on our 520. CHGVAR     VAR(&CMM) +                                                VALUE('/usr/local/Zend/Core/bin/php +                    /www/zendcore/htdocs/test.php') QSH        CMD(&CMD) i try to send an email in the php script and i was wondering why it takes about 5-8 seconds to send the mail. So i tried to find out where the script is slow. [...]

Answer Question   |  March 31, 2010  12:45 PM
CL, i5, PHP, Qshell

Can Websphere Tivoli Logging be started using a QSHELL Command?
We’ve recently upgraded Websphere to 6.1 and Tivoli logging has changed to a more ‘web’ based interface. However starting logging using this interface has become a long winded affair and I was wondering if this could be acheived using a shell command? Much in the same way that websphere instances can be started and ended.

Answer Question   |  June 12, 2009  1:23 PM
IBM Tivoli, Qshell, Tivoli, WebSphere

Qshell error from a CLP
i correct CPFB9C8 qshell error from my cl call

Answer Question   |  February 18, 2010  12:45 AM
AS/400 Control Language, CL, Qshell, QShell Error CPFB9C8

Qshell filename size limit
I’m trying to use Qshell to copy a file from server to server and rename it with a date/time stamp… e.g. file.txt to file090220091000.txt and there seems to be a limit of 12 characters for the complete “target” name, including the .txt; can anyone help? Thanks

Answer Question   |  February 23, 2009  2:12 PM
Qshell, QShell Filename Size

call php from cl
Hello, i call a php program from my cl with CALL PGM(QP2SHELL) … the php is called, but then opens the QSHELL. can i close the QSHELL from my php programm? Or can i call a php programm without starting qshell? btw. can i sent parms back to the cl from php? Thanks for your [...]

Answer Question   |  April 7, 2010  4:15 PM
AS/400, CL, PHP, Qshell

File sort using qshell (this time with tags)
Hi, I’m trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a sort, removing duplicate records, and [...]

Answer Question   |  January 16, 2008  3:12 PM
AS/400, Database, DB2, Linux, Qshell, Unix shells

as400 copy qsys.lib directory to mapped I drive
I need to be able to copy an as400 qsys.lib/ sub-library/ or speceific files (*.FILE) in that sub-libray to a mapped drive I. Drive I is on the as400 which my PC can access. I do not know the path on the as400 to the I drive. I would like to use qshell if at [...]

Answer Question   |  June 9, 2008  6:40 PM
AS/400, Qshell