CLP

Unattended savsys

I will be moving my backup AS/400 to a secure building for D.R. purposes. I need to figure out a way to automatically get a savsys done without doing it from the console. We are on V5R3. Right now I have a cl setup with all of the save commands but when the endsbs *all *immed (with batch limit...

Journal Receiver Sequencing

Hi All, We have a test and production data library, we have a separate journal for each that fill journal receivers in their respective libraries. In TEST our system managed receivers always start at sequence 1 when a new receiver is attached, in production the sequence number continues from the...

Blocking certain fields from being downloaded using Client Access

Hi, By using WRKQRY, we can select the files and create output files. My problem is how do I block certain users from downloading certain sensitive fields like Price in the output file. Thanks..

RLU Document

Hi I have been working with program described printer files till now. But I would have to start working on externally described printer files. I know we can use RLU to design externally described printer files but I do not know how to use RLU. Can anyone please point me to any document on how to...

Printing from RPG based program straight to printer without going thru output queu

Hi I need to change by inhouse RPG programs to print direct to the printer output queue without going through the spool files. Anybody knows how can this be done? Is there any CL programming required? Thanks

can strqmqry be run as remote command

I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...

CPYTOIMPF Nightmare

I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields - and it appears to be random. Here is my command CPYTOIMPF FROMFILE(*LIBL/IOBEXT) + ...

MS SQL Server 2000

Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

SYNON vs COBOL

Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

Single quotes around a CL variable

The easiest way to do the above please

MONMSG and SNDRPY

Dear, I'm trying to write a small program to run my backup job via BRMS... and I would like to check the different errors and reply automatically to few of them. Ok, I can monitor the error messages through MONMSG but how can I reply to them ? I know that I have to use SNDRPY but how can I have the...

create computations on the fly

We are primarily a COBOL shop. We have some COBOL ILE and some RPG. I have a need to replicate a function on the I-series that is currently done in Excel. This function allows them to create formulas on the fly to arrive at pricing information. I can work through issues with interactive...

Week number

I can't see a system value for the week number. Is it held somewhere else on the i5 system or does anyone have a CL program they've written and willing to share to calculate it ? Thanks.

QDLS and the IFS

How can I access the QDLS library in a CLLE program? I am using the copy database to an optical file command and CLLE program (CPYDBOPT). I created a folder called "Optical". I can see this folder using iSeries Navigator. I don't see a QDLS library on my iSeries when use I use the work with...

Connect:Direct CDSND command

Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?

iSeries (AS/400) - Wanting to print to PDF using GhostScript or other software

We have PostScript files on the AS/400 and we need to convert them to PCL for printing and also to PDF. Having much trouble getting Ghostscript even to compile on the AS/400, so I am looking for another "free" method to do what we need. Our software runs in a browser window connected to the...

Array Corruption

I have written an RPGLE pgm in which I took an array with a size of 400 (20 fields with a length of 20) and did a MOVEA to put it inside a character field of 400. I then passed this field to another program and I did a MOVEA to populate the array in the 2nd program. When I call the 2nd program...

CLP training tutorial

hello, I was wondering if there were any CLP programming tutorials available? Or maybe even some sort of online training? Cedric

Monitoring VRYCFG

Hello, Well, I need some advice because I'm one more time a little bit lost in my learning of AS/400 programming. Here is what I'm trying to do: Everytime that the AS/400 receives a VARY OFF on 1 specific device, I would like to execute a program after the VARY OFF is complete. I was thinking of...

The server with this database is no longer responding

I am trying to access a link in a Database on the LNS through the lotus client but it is throwing the error message 'The server with this DB is no longer responding Should notes switch to a replica on other server'. The link is accessible from a other client.I have shutdown the firewall...