Hi All, In a program, a loop doing some operations… and I got some program error/file error and in *PSSR I want to handle the error then to resume the program to flow with the next record. But, how to pass the control to the loop to read from the next continution record. In Main…

How do you initiate a direct web service call from the AS/400? I am programming in 400/COBOL. I am assuming I need to use COBOL ILE.

i have a subfile with sflpag=sflsiz=10. say in PF total records are 25. when in load subfile in 3rd page i see only 5 records.But my requirement is to see 5 records from PF & 5 blank rows. I tried to do it using sflinz and sflrna.I used a indicator with sflinz.when writing SFLCTL i…

Hi, I have to set up alert at a specific time on AS400 which will check if the backup job is running. If the backup is not running at that specific time,it should send an alert’Backup Not Running’ else it should send an alert’Backup is running’/'Backup is in Message Wait’. Can anyone please suggest me…

My system gets data in flat file for booking.Once the booking is completed , customer sends some corrections data in other flat file. I have to compare both flat files data in window based comparison tool like EXamdiff Pro . if sent correction notes is ok, then update the physical files.  example Original flat file…

Hi All, I am working on a project to send spooled files through an outq to a wintel server running esker fax. We have done this on many occasion with out any problems. However, This time the spooled files contain French alphabet characters. When the spool file arrives on the wintel server the French alphabet…

Printing reports from an AS400 to a Xerox printer. If the printer fails no one knows until the next day. Trying to find the file the next day is horrid. Is there anyway to confirm and hold the file if it failed?

On OS400, Is there a way to manage limitation for permissible librairies when they use the command WRKQRY? And for those limited librairies can we assign a limit or quota to the storage usage per user id ou user group to avoid creation of enourmous files? Thanks in advance for reply on that,

We are using LTO4 ultrium tape for backups in our server{V5R4}. System Total Storage – 12TB Present ASP              – 60% i.e.,{More than 6 TB} For Entire System backup - Two Ultrium 4 tapes used. {which has the size of 1.6Tb each for compressed data = total  3.2Tb} Question : Since the ASP is 60% we can predict…

Hi, I have iTera HA 5.0 installed.While doing the regular check on DR box,in Mirrored Object Maintenance screen ,I find one object LOCK1191 in Lib DBSLIB is not being journalled.On checking the status of DBSLIB on production box,the status shows SYNCING.But this status remains as it is for last 2 days   . How do I make…

Hi All, Oracle Database Version : 9.2.0.8.0 Some of the datafiles status have been changed to ‘RECOVER’, because the datafiles are physically missing… Now, how can i find that when (timestamp) the status of the datafiles have been changed, as i am unable to find when the datafiles have been physically lost? Please consider both…

Hello There. I’m trying to connect to the outside world but my eth port is connected to my power 7 box. Is there a way to ‘share or split’ this port ? Either thru some kind of swithch or software that somehow would create a lan console ? I’m trying to make what I have…

Hi recently i discovered that my data transfer from iseries server aplication does not apply the object authority that i have in place so, all of my users can browse and download objects that they arent supposed to. My question would be if theres any way to disable the browse button on the apllication so…

Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or avatar to be eligible…

Is there any way we can display a message “Processing” while the program is building the data in a subfile. In CL we can use the SNDF command to send such message to the display. Please help.

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…

What has to change in the script below in order to generate more than one entry to the outfile? I am capturing the data to send to an outfile but it only posted the first occurence to the dataset   /* REXX */ ADDRESS TSO “ALLOC FI(OUTFILE) DSNAME(‘xxxxx.xxxxxxxx.xxxxxx’) MOD REUSE” DAYS = DATE(“B”) NEWDATE =…

Signed on to Iseries V6Ri with Client Access version 5.9 for Windows, received the follewing application error: Faulting application pcscm.exe version 5090.2.8121.38 faulting module pcstlnet.dll, version 5090.3.8263.679, fault address 0x0000720c, not sure what it is and how to fix.

Hi, wonder if these xml functions (XML2CLOB, XMLELEMENT, XMLATTRIBUTES, XMLAGG, …) can be used in db/400 — as/400 V6R1M0, if yes, any sample code? of not what else I can use to generate xml content from db2 queries? Any answer is appreciated.

Trying to print from my AS/440 to lexmark 540n,when I release the file from the AS/400 a message appears saying the printer the lexmark has put the file on hold and cancelled the printing