V5R4M0 Questions and Answers

Recent IT Questions

1 - 12 of 12
<<PREVIOUS 1 NEXT>>

SQLCODE = 1077952576

All- I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas?  It's not in the SQLCODE finder. Phil ...

View Answer   |  Nov 2 2009  11:02 PM GMT
RPGLE, RPGSQL, V5R4
asked by MurrayInfoSys

  560 pts.

Delete Spool Files of 30 users (Starting with OP) using Generic Name i.e. OP*

Every 3 moths we are deleting Spool files of users Starting With OP, on iSeries System using the below Program and a Display File. This activity is performed after the Spool Files (Which needs to be deleted) are saved on Tape using BRMS. *************** Beginning of data...

View Answer   |  Oct 28 2009  7:33 AM GMT
Spool files, CL/400, AS/400 Spooled Files
asked by Haaiderali

  65 pts.

Secured TELNET

How can I secure telnet so one cannot just telnet to our systm name and access a QPADEV* session? TIA Software/Hardware used: iSeries O/S V5R4M0

View Answer   |  Oct 12 2009  1:22 PM GMT
Secured TELNET, Telnet, V5R4M0
asked by Abigail

  215 pts.

Best way to retrieve values, SQL or Queries and how?

Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like (  60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record  {4: ...

View Answer   |  Oct 1 2009  10:33 AM GMT
SQL, Query/400, CLP
asked by BUG68

  80 pts.

Defining a sort variable (ORDER by) in RPG SQL

I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG...

View Answer   |  Sep 3 2009  2:12 PM GMT
RPGSQL, SQL, RPG
asked by MurrayInfoSys

  560 pts.

Track total Batch jobs per jobq daily

Is there a function to track the total number of Batch jobs run per jobq on a daily basis? I don't see anything in collection services and we do not have PM. Software/Hardware used: i525, v5r4m0

View Answer   |  Aug 27 2009  8:57 PM GMT
AS/400, AS/400 batch jobs, i5 525
asked by Whatis23

  3890 pts.

Error message CPF0CBF

I received the following error message and haven't been able to find any information on it. Has anyone seen this before? Message ID . . . . . . : CPF0CBF Severity . . . . . . . : 20 Message type . . . . . : Escape Date sent . . . . . . : 08/12/09 Time sent . . . . . . : 11:45:43 Message . . . . :...

View Answer   |  Aug 13 2009  6:42 PM GMT
AS/400 error messages, AS/400 errors, V5R4M0
asked by ADmobius

  185 pts.

Authority to joblogs

How can I permit the programmers access to joblogs of users with a higher security?

View Answer   |  May 22 2009  3:33 PM GMT
iSeries, DSPJOBLOG, V5R4M0
asked by Lorizubie

  5 pts.

How to email reports from OS V5R4M0

How can I email reports to my users from OS V5R4M0?

View Answer   |  May 11 2009  3:18 PM GMT
V5R4M0, AS/400 reporting
asked by Kkharper

  5 pts.

v5r4 and printing

Since upgrading to v5r4, we have a problem printing an OPTIO Software form. We have an IKON PRO125VP printer. Once the file is done spooling to the printer, the print job goes on hold and stops prining the job.

View Answer   |  Apr 27 2009  1:39 PM GMT
V5R4M0, V5R4, AS/400 upgrades
asked by Tink

  10 pts.

No Source Showing

When I compile my RPGLE source I do it with the *source for dubugging. I just noticed this was happening. Now when I try to do a display object descrition i do not get where the source was compiled from. ANy Ideas why? I need this ASAP. Thanks Source file . . . . . . . . . . . . : ...

View Answer   |  Mar 27 2009  6:28 PM GMT
AS/400, RPG, RPGLE
asked by RonKoontz

  1310 pts.

FTP Source File transfers between to AS/400 systems

I have written a bound ILE CLP and RPG comand/program that will allow LIB/FILE.source transfers between two AS/400 systems and/or LPARS using FTP. It works fine with the exception that the source files are transferred with out the Descriptive TEXT. Does anyone know how to solve this dilemma? We...

View Answer   |  Dec 23 2008  3:20 PM GMT
RPG, FTP, OS/400 TCP/IP
asked by ECLAY

  20 pts.

1 - 12 of 12
<<PREVIOUS 1 NEXT>>