No such path in wrkflr
CPYFRMIMPF FROMSTMF(‘/SANWEIGH/SANSPACE.CSV’) TOFILE(AXMTESTLIB/SANSPACE01 ) MBROPT(*REPLACE) RCDDLM(*CRLF) File system error occurred. Error number 3025. Copy command ended because of error.

Answer Question   |  November 18, 2011  7:07 PM
as/400 data

CPYTOIMPF issue in AS400
Hi I have a problem while iam doing the CPYTOIMPF. Iam getting the error as copy didnot complete because of reason code 1.it means CCSID of to file and from file is not matching? iam using the below command to do so  CPYTOIMPF FROMFILE(ARCPGM/&WFLENM) TOSTMF(&CSVDIR) + MBROPT(*ADD) STMFCODPAG(*PCASCII) + RCDDLM(*CRLF) DTAFMT(*DLM) NULLIND(*YES) ARCPGM – library [...]

Answer Question   |  November 16, 2011  11:54 AM
AS/400

rpgle in as400
how to end the program without using seton lr and return opcode..

Answer Question   |  November 23, 2011  10:21 AM
RPGLE Program

DYNSLT (Dynamic Select Concept)
Hello All, This question is regarding the dynamic selection concept in DB2/400. As we know we can create a LF with our without the DYNSLT keyword. The question is what is the difference in using LF with and without DYNSLT? What should I prefer if my PF handles millions of records? Thanks in advance

Answer Question   |  November 16, 2011  9:53 AM
DB2/400

taplib issue
In one system tapmlb01 device varied off and back on after an IPL. please help me WHY this needs to go offline/online for these systems when it doesn’t do the same on the rest

Answer Question   |  November 18, 2011  5:12 AM
AS 400

IPL issue
i am getting an IPL/PATCH screen after pwrdwnsys. Re-performed IPL by selecting option 1. Additional options were for installing an OS, patching, etc. Doing the IPL like this brings the system through selecting ptfs. The Control Panel shows Manual instead of Normal. This is causing a delay in the IPL process.Please help me to avoid [...]

Answer Question   |  November 29, 2011  3:25 AM
AS/400 errors at IPL, AS/400 IPL

IT Data Updates and Auditors
I would like to hear how other shops deal with auditors regarding data updates made by IT staff.   We use DFU/FILMNT/SQL for occasional data fixes. We print and file a log with who and why the change was made. Then to appease the auditors, we journal pretty much everything. A report is generated twice a [...]

Answer Question   |  November 18, 2011  12:01 AM
AS/400, Auditors, DFU, FILMNT, iSeries, SQL

CPF4328 & FILE CONSTRAINT with *RESTRICT Rules
10 years ago we sent out a pair of PF tied together by a constraint. Client is now receiving CPF4328 while updating “parent” file. DLT & UPD rules were created as *RESTRICT which should allow update without journaling. Is there a way to see DLT & UPD rules on green screen? Or, should I just [...]

Answer Question   |  January 31, 2012  7:37 PM
AS/400, Constraint, CPF4328, PF

AS400 DSPF Overlay
I’m having problems with a simple overlay issue. I have a screen where a user can do an F4 and a window of the values from a table will appear in a SFL. All works well; except the new wilndow does not overlay the previous screen. THe old screen goes away and I just have [...]

Answer Question   |  November 16, 2011  7:29 PM
AS/400

user profile
what is the parameter accounting code in userprofile?

Answer Question   |  November 16, 2011  12:59 PM
AS/400

Encoded vector view in AS400
Hi I have a question on encoded vector view.what exactly it is. As iam using normal logical files using DDS.this logical files iam using in rpgle programs to read the file and update in my work file. Now my people are saying that logical files are taking more space on system. They are suggesting me [...]

Answer Question   |  November 16, 2011  12:53 PM
AS/400

Question on CL.
Hi Group, I would like to enter input to a CL pgm through console. For example, My CL PGM should take file name as the input from the console and has to display the number of records that are present in that file. Thanks in Advance, MVRK

Answer Question   |  November 16, 2011  1:40 AM
CL/400

how do I open and update EXCEL sheetsheet from AS400?
this batch file is called by a RPG program from AS400, i5/OS the first four lines executes properly, then it goes into a TIMW that never ends. If I exclude the  c:spreadsheetopexcels.exe statement (my primary need), it executes properly. ************************************************************************************* *mybatfile.bat cd c: cd c:SPREADSHEET rem the line below creates an excel spreadsheet ESA002F2.xls “c:program [...]

Answer Question   |  March 20, 2012  7:17 PM
AS/400, Excel Scripts

Problem converting numeric to date data type
I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql…It giving error ..please help me out ..I tried using date and cast function but its not working !!

Answer Question   |  March 19, 2012  11:24 PM
DB2/400, SQL

AS400 – SQLRPGLE
Hi, We are moving Values to Database Fields using Embedded SQL Concept. In Embedded SQL, We can decide the Variable Names dynamically. Is it possible with Display File? why?

Answer Question   |  March 17, 2012  9:49 AM
AS/400 Display File, AS400 - Embedded SQL, Dynamic SQL, Embedded SQL, SQLRPGLE

AS400 – RPGLE
I want to move some values to variable in RPGLE Program. I want to decide the Variable name based on the value which i received. Eg: If i am getting ‘DEmail:xxxx@xxx.com’ from my calling program, i want to move to DEmail Field. All the Fields are available in Display File. How will i achieve this. [...]

Answer Question   |  March 17, 2012  9:46 AM
AS400 RPGLE, Display File

Same file in different libraries and file is defined once in an RPGLE program
I have a coding project that requires the following.

Answer Question   |  March 17, 2012  11:45 PM
Coding, DB LIBRARIES, RPGLE

iSeries RPG
Hello, Is it possible to create some kind of RPG sevice program that will reseide in the memory and await for a function key pressed while another program with its own DSPF is interacting with user? For example, user is intereacting with an input screen and secret functional key will allow a popup screen to [...]

Answer Question   |  March 17, 2012  1:22 PM
AS400. RPG, iSeries RPG programming, RPGIV

Is Movex Workplace better on iSeries or Windows?
Hi,  we are planning to upgrade iseries system to V6R1,so please suggest whether to go for higher version of Movex WP on iseries or you want to go for Movex WorkPlace on Windows platform.i mean in terms of cost effectiveness and manageable over a long run. Please suggest… Regards S.Manjunath      

Answer Question   |  March 17, 2012  11:40 AM
AS/400, Movex, Windows

AS400 – DDS Keyword
I want to use MOUBTN Keyword with specific Field. Eg: If i click Test “Enter to Process” in my Screen, Process operation needs to be executed. (Like On – Click in VB). How to do in AS400 Display Screen

Answer Question   |  March 17, 2012  9:28 AM
AS/400 - DDS