Which job serve the IFS conection?
Hi, I know that the SQL connection is managed by the job QZDASOINIT, I would like to know which is the job that manage the IFS connection through UNC path ? I mean if my server name is : server050.domain.lab and I put that UNC path into a windows which is the job that actually [...]

Answer Question   |  November 27, 2012  9:05 PM
iseries v5r4, QZDASOINIT

SNDTCPSPLF Freeze
We use SNDTCPSPLF to send spool files from a clients V7.1 machine to our v5.4 machine. This happens every 10 minutes or so. The problem is that recently the send has been going to Status SELW and hanging there. We have to end the sending job and start a new job and away it goes [...]

Answer Question   |  June 26, 2012  9:51 PM
iseries v5r4, iSeries v7.1, SNDTCPSPLF

Table naming issues while migrating I-series v5r4 to Oracle
hi sir, will a migration possible between iseries v5r4 to oracle ?? if it is possible then will there be any issues regarding  table naming i,e tables having names more than 10 charecters will get migrated ?? here  in our scenario our source db has tables with names more than 10 charecters and the db is [...]

Answer Question   |  June 26, 2012  12:17 PM
iseries v5r4, Oracle

Compare part of string to field
Hi.  Hopefully a simple one but beyond my self-taught abilities in iSeries SQL.  I have a file with one field containing customer order details including their purchase order reference such as ‘A1-123′.  The first part of the PO reference is a branch identifier.  Unfortunately, as it is a free text field, it is sometimes expressed [...]

Answer Question   |  May 16, 2012  10:40 AM
iSeries SQL, iseries v5r4

Getting Apache REMOTE_USE variable (CGIDEV2)
My RPG on iSeries program doesn’t seem to get the REMOTE_USE variable when it is responding to a web call from a Reverse Proxy server (Apache/Linux/PHP). I am using getenv() function from CGIDEV2 library and it works perfectly when the call comes from within the LAN. If the call comes from the reverse proxy, function [...]

Answer Question   |  April 10, 2012  5:06 PM
iSeries RPG, iseries v5r4

CPYFRMIMP inserting quotation marks
I am trying to use CPYFRMIMPF to copy a tab delimited file to a physical file.  The problem I have is that the file has commas (,) in the text and  CPYFRMIMPF automatically inserts quotation marks around the text whenever there is a comma in the field. For example, if my tab delimited file has 2 [...]

Answer Question   |  March 30, 2012  3:33 PM
AS400 iseries, CPYFRMIMPF, iseries v5r4

iSeries NFS: Change from UDP to TCP
We are running on V5R4 and attempting to mount (via NFS) an external file system (Data Domain 530) onto the iSeries. Even though on the surface it appears that the mount was successful; you cannot execute any type of read or write operation to the mount. After running a communications trace, it was determined that [...]

Answer Question   |  March 19, 2012  10:14 PM
iseries v5r4, NFS, TCP, UDP

Highlighting messages in a queue?
Is there some way to add a field attribute to a message sent to a message queue?

Answer Question   |  March 19, 2012  11:13 PM
iSeries message queues, iseries v5r4

Client Access: IP or DNS?
Can I tell by looking on the system if my users are accessing the box via IP or DNS or do I have to vist each PC to check config?

Answer Question   |  March 21, 2012  9:58 AM
Client Access, iseries v5r4, Power6

Web query options not displayed
I am working through the Redbook on Web Query. I have logged on as an administrator through the browser and created a new domain. Next step is to create metadata and that should be accessed via a drop down menu on the reports folder. The only options I have when I right click the reports [...]

Answer Question   |  March 19, 2012  6:57 AM
iSeries, iseries v5r4, web query

Lost License Key After IPL
We have not IPL the system in over a year. Upon doing so we lost the license key. How could this issue happen. We only IPL the system , we made no changes. System V5R4

Answer Question   |  March 17, 2012  2:54 PM
iseries v5r4

FTP from QTXTSRC
I previously sent this question around 2 A.M. est.  This revised version should be more coherent.  How do you send data in a QTXTSRC member via the IFS in order to FTP it from a dos prompt or in a CLP? I created a stream file but I am receiving “File not found” when I [...]

Answer Question   |  December 23, 2010  7:28 AM
FTP, FTP management, FTP QTXTSRC data, iseries v5r4, V5R4

Deleting unmatched records from a file in iseries SQL
I’m trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100                                   WHERE SHListNo = ALL                                           ( SELECT SHListNo FROM DVMURRAY/INSRP100 Left Outer Join  DVMURRAY/INSRP200                                                       on SHListNo = SDListNo                                       WHERE SDListNo is Null                                )                                                       Row not found for DELETE.                             [...]

Answer Question   |  November 24, 2010  5:31 PM
iSeries SQL, iseries v5r4, RPGSQL, SQL, V5R4

getting alot of Quser/Qzdasonit jobs going into wrap throughout the day.
Hi all. Im not sure if this is a problem or not, but im getting alot of Quser/Qzdasonit jobs going into wrap throughout the day. When I display the individual jobs im seeing the following message looping. Cannot resolve to object USTAXCLP. Type and Subtype X’0201′ Authority. The jobs use the QDFTSVR job description – [...]

Answer Question   |  July 21, 2010  3:02 PM
AS/400 jobs, iSeries, iseries v5r4, QZDASONIT, V5R4

ENDJRNPF Shortcoming in V5R4
If in V6R1, issuing the command ENDJRNPF completes without any error even if a PF or LF of that PF is open in some other program, then what is the solution for shops that only have V5R4? I need to end journaling for files but the ENDJRNPF fails because some of the LFs for the [...]

Answer Question   |  February 8, 2012  10:45 AM
ENDJRNPF, iseries v5r4, iSeries V6R1, PTFs

Printing to a ZEBRA S4M from the iSeries
I need to print simple labels – no bar codes, just different font sizes – from the iSeries (perferably from an RPG ILE program). Is anyone doing this without using some third party software? If so, how? Thanks for your help. JP

Answer Question   |  November 29, 2011  12:33 PM
i5/OS, iseries v5r4, RPG ILE, Zebra S4M

AS/400 V5R4 – Trying to run a system save in nightly routines.
AS/400 V5R4 – Trying to run a system save in nightly routines. ENDSYS *ALL submitted to QCTL with parameter BCHTIMLMT set for enough time for SAVSYS to run. System does go into restricted state but then Subsystem QCTL starts straight after (2 mins). How do I keep system in a resricted state? What am I [...]

Answer Question   |  June 28, 2010  3:24 PM
AS/400, ENDSBS, iseries v5r4, SAVSYS

CPYF w/INCREL copying too many records
I’m using the following command: CPYF FROMFILE(REIDATA/DESGDTL) TOFILE(ISJN/DESG73133) MBROPT(*ADD) INCREL((*IF DSDID *EQ ’73133′)) … in the file I am ending up with records containing both ’73133′ and ’73133-1′ in the file.  The field DSDID is the primary key to the file.  In summary it is acting as if it were a LIKE instead of a [...]

Answer Question   |  June 21, 2010  2:14 PM
CPYF, iSeries Commands, iseries v5r4

How can I see when a user signs onto iSeries to check their profile?
I need to know a user signs on the iSeries so I can check the profile aganist a file to disable the profile or not. How can I get this information??

Answer Question   |  June 22, 2010  5:30 PM
iSeries, iseries v5r4, V5R4M0

RPG with Embedded SQL needs journaling
When I try updating data in a PF via embedded SQL I get a message saying I need to turn journaling on..   *  change dates on a set of records   C/EXEC SQL                             C+ UPDATE ACC02602P                    C+   SET   CSSTR8 = :$NEWSTR,          C+         CSEND8 = :$NEWEND           C+   WHERE CSSTR8 = :$CSSTR8  AND      C+         CSEND8 = :$CSEND8  [...]

Answer Question   |  October 15, 2010  8:39 PM
AS/400, Embedded SQL, iseries v5r4, RPG