ROLLBACK in CL program

How to use ROLLBACK command in CL program?

suryathiru10 pointsBadges:

RPG/400 Error RNQ1255

I have a RPGILE (XOP560) program. I am able to compile sucessfully this program. once i call this program i am getting below error. please advice me. Additional Message Information Message ID . . . . . . : RNQ1255 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . :...

Askt265 pointsBadges:

Zipped file won’t open: File is invalid

I zipped a file using shell command in AS/400. When I FTP the file, its working but when I send it through email, I couldn't open the file as it says "file is invalid " Could someone help to fix this issue?

sat1984105 pointsBadges:

Rounding values in AS/400

Hi, Why the result is 164.20 and not 164.19? The statement: MULTIPLY W-AMOUNT BY 0.06 GIVING W-GSTAMT ROUNDED The definition; W-AMOUNT PIC S9(014)V9(002). W-GSTAMT PIC S9(014)V9(002). Where the value of W-AMOUNT is 2736.57. Thanks, Azman

Azmanh5 pointsBadges:

How to create read-only user in AS/400

I want to create admin user who can only read objects like userprofile, group profile and authorization list but does not having permission to modify these objects.

anand12345615 pointsBadges:

Create a .txt file on AS/400 IFS

I have created a file on my AS/400 using CRTPF with a 10 character name. This file is to be sent to another server. The application on the receiving server requires a .txt file with a specific name format. The name is 42 characters in length. How do I do this?

chasattard65 pointsBadges:

changing a group profile to a user profile?

One of my predecessors thought it was a great idea to add users to the QSYSOPR profile, which changed it from a regular user profile to a group profile. I have since moved these users to other groups, but QSYSOPR still thinks it's a group even though there are no members. Short of deleting this...

Jgowin0 pointsBadges:

iSeries SQL0904 Resource limit exceeded

I have written RPG/ILE stored procedures to validate and write data to various physical files with data extracted from MSSQL tables using SSIS and MS Visual Studio 2013 and utilizing the Native OLE DBIBM DB2 for i IBMDA400 OLE DB Provider. My problem the extract job fails when trying to import...

JustJamesG5 pointsBadges:

Excel add-in data transfer error CWBTF0012

I'm having a data transfer issue. I get the CWBTF0012 general error. Looking it up it say reached max records. Here is the strange thing, I'm still under that number of records. According to what I have seen it relates to Excel 2007. I am currently using Excel 2010. I do have the client access...

ToddN2000129,825 pointsBadges:

AS/400 – Menu to program mapping

Hi, I want to extract the complete list of Menu and the programs associated to it. Is there a system file I can look into where I will be getting the mapping of Menu/Screen to program mapping.

Zvarghese20 pointsBadges:

Corrupt .dbf files

Dear Sir/Madam, I am using a software bases on Clipper, i made all the entries and then I indexed. The program stopped working and closed. Since then I'm unable to retrieve the latest data from the .dbf files. Thanking you in advance.

pliv8315 pointsBadges:

Error on AS/400 scheduled job

Error on scheduled job - SFTP file transfer encountered error. File transfer started but the final QUIT command was not detected.

as400lu40 pointsBadges:

Can Parameter be passed to/from OCL procedure

Can a parameter be passed to/from an OCL procedure (as opposed to CL program)?

dmills5 pointsBadges:

AS/400: Remove group member from group profile

How can I remove a particular group member from the group profile? How can I get a user profile, group profile list in C#? How can I get a group profile member list in C#?

manite25 pointsBadges:

Remote Option 21 entire system save

Hi, Would anyone know if there is a way to do a remote option 21 save on AS/400 instead of going through the: "QSECOFR Opt 3. Gen system tasks Opt 6. Save Opt 21. Entire system" If this is at all possible? The console is still the old IBM console, is it necessary to change to a remote console? Much...

LeoLyon20 pointsBadges:

QSECOFR Audit

How can I create a report showing when QSECOFR logged on the system for a six month period?

chuckalugk25 pointsBadges:

AS/400 CL Unit of Work Question

Assuming I am not using any commit control statements and I have a simple CL that executes 2 RPG programs (one after the other); I'll call them step 1 and step 2. Is there a single unit of work that covers both steps or is each step the beginning and ending of a unit of work? That is to say, in...

boneshark5 pointsBadges:

AS/400 user profile issue

I cannot see anything in my :apps" for my AS/400 user profile only.

jaleelkm5 pointsBadges:

24 digit number: Arithmetic operations?

Hi, I need to work with numbers which are digits long. Why? Because this is the way to create a German IBAN code from Bank Code and Bank account: Concatenate Bank Code (8 digits) plus Account nbr (10 digits, leading zeroes) plus "131400" to a 24 digit number. Compute Modulo 97 of this number. (or...

gast95185 pointsBadges:

How to omit some libraries?

When we are taking backup using BRMS, I want to omit some of the libraries when we are taking backup for *ALLUSR libraries. Please provide the solution. Thanks in advance.

Flakek60 pointsBadges: