How do you transfer from PC excel file to AS400 iSeries

Tried .xls and .pdf to transfer.



Answer Question   |  January 3, 2013  2:38 PM
AS/400, Microsoft Excel files
asked by:
5 pts.

CPW in iSeries

Do we have any formula for calculate CPW ? Did the environment size is estimated based on CPW size in iSeries ?



Answer Question   |  January 2, 2013  12:08 PM
AS/400, CPW
asked by:
11,410 pts.

AS/400 Record Lock

CL control program Starts commitment control STRCMTCTL LCKLVL(*CHG) CMTSCOPE(*JOB) Calls a complex sequence of RPGLE programs Issues COMMIT Issues ENDCMTCTL A rather complicated series of RPGLE programs: open files for update read records sometimes update records sometimes call other programs sometimes close files Sometimes issue *INLR = On Is there any way that a record…



Answer Question   |  December 28, 2012  2:22 PM
AS/400, AS/400 record locks, Commitment control
asked by:
44,190 pts.

History Logs

Have a question conerning History Logs, since the logs continue to grow, we back the logs up and save them to Tape. However we need to look at some of the logs on the system, here is the issue. We can restore the logs however there is another log with the same name on the…



Answer Question   |  December 28, 2012  10:31 PM
DSPLOG, OS/400
asked by:
20 pts.

AS400, CLLE OPENID Already Exist Error

Hi all. ! OPNID(M1AMC00) for file M1AMC00 already exists. CPF4174 received by procedure NONCLP. (C D I R). I’m getting this kind of error: what will be the solution? Surey



Answer Question   |  December 27, 2012  6:00 AM
AS/400, CPF4174
asked by:
1,485 pts.

rslvsp function returns null

Documentation for rslvsp points: “A null pointer value means the object was found in a machine context.” But I verified that my user space was created successsful rslvsp(_Usrspc,”userspace”, “QTEMP”, _AUTH_ALL) If it is found in machine context, how can I resolve to it (Have a pointer to the user space)? if is not in a…



Answer Question   |  December 21, 2012  9:41 PM
API, iSeries, rslvsp function, V6R1
asked by:
340 pts.

compiling cl program, ownership issues

i added a commment line to a current CL program. when i went to compile it thefollowing error message appeared Owner of object COPPK1 and object being replaced not the same. any ideas?



Answer Question   |  December 20, 2012  8:58 PM
CL Program, compling, i series
asked by:
10 pts.

AS400 Subfile session or device error

DOW *in12 = ’0′ Seton 2526 Write blank Write foot1 WRITE MSGSFC Exfmt sfc01 call ‘L1000C’ These codes are from my program when i’m executing these pgm im getting seesion or device error. I checked with debugging , when the execution comes to the EXFMT line its showing the error.. Pls giv me some suggestion..…



Answer Question   |  December 20, 2012  7:33 AM
AS400 Subfile, error
asked by:
1,485 pts.

AS/400 administration certification

i am planning to take AS/400 administration certification test can some one help me with Dumps please



Answer Question   |  December 20, 2012  3:20 AM
AS/400 administration
asked by:
265 pts.

TCP/IP

I am getting this error on TCP/IP connection. Emails are not going out from AS/400 “2 = TCP connection closed due to R2 retry threshold being run.”



Answer Question   |  December 19, 2012  6:12 PM
AS/400, TCP/IP
asked by:
40 pts.

STRMSF

When I start MSF (STRMSF) I get this error Message . . . . : Job 268354/QMSF/QMSF stopped processing MSF message. Cause . . . . . : Exit point program QTMSFWD in library QTCP for exit point QIBM_QZMFMSF_MSG_FWD has detected a condition with message ID 10E92AD1212191154300000000048. The message indicates that processing should be ended.…



Answer Question   |  December 19, 2012  5:32 PM
AS/400, strmsf
asked by:
40 pts.

How to pass parameter from Equation Option(ex:CUE) to RPGLE!

How to pass parameter from Equation Option(ex:CUE) to RPGLE progam??



Answer Question   |  December 19, 2012  1:05 PM
AS/400, i series, RPGLE
asked by:
10 pts.

AS/400

I tried commitment control for that I created file salary dds is as follow A R RSALARY A NAME 10 A SURNAME 10 A SAL 10 0 created one disply file for that dds is as follow A*%%TS SD 20121218 034714 KRGUNN REL-V6R1M0 5761-WDS A*%%EC A DSPSIZ(24 80 *DS3) A R RSALDSPF A*%%TS SD 20121218…



Answer Question   |  December 19, 2012  6:08 AM
AS/400, AS/400 commands
asked by:
200 pts.

How to avoid MSGW in a DATA Queue

I have a Program A which sends a message to a data queue , There is a job running on the System i , which monitor this data queue , and when it receives a message in this queue a set of programs is called . The problem is when one of the programs has…



Answer Question   |  December 19, 2012  4:35 AM
AS/400, Data Queue, MSGW
asked by:
225 pts.

SNDDST

sending multiple attachments in SNDDST



Answer Question   |  December 18, 2012  9:22 PM
SNDDST
asked by:
10 pts.

IBMDA400 Date Issues

The IBMDA400 provider seems to convert dates to character values even when using keyword “Convert Date Time To Char=FALSE”. This does not happen with the ODBC driver or IBMDASQL provider. I’d be okay with IBMDASQL except IBM states it only works the SQL statements. I’d be okay with ODBC driver except records can be doubled…



Answer Question   |  December 18, 2012  4:33 PM
AS/400, iSeries, ODBC
asked by:
11,410 pts.

Message Ids in Message File

How to check whether a msg id is moved today or when? For E.g. If MsgId UR000 is moved to MsgF SSA000 on 24 Dec 2012 and Again the same msg id needs to be moved on a particular day then how to identity the last date of its Movement? I performed the below steps:-…



Answer Question   |  December 18, 2012  1:57 PM
AS400 admin
asked by:
355 pts.

Access to DB2 from Oracle

I want to access the DB2 database on iSeries from Oracle 11 (read and write). What is the best way?



Answer Question   |  December 18, 2012  11:11 AM
DB2 database, iSeries, Oracle 11
asked by:
15 pts.

Subfile fold and drop

Hi, please some give me some idea about subfile fold and drop .



Answer Question   |  December 14, 2012  10:53 AM
AS/400, AS/400 Subfiles
asked by:
1,240 pts.

Share objects between two AS/400 machines on a same network.

Hello, I would like to know if it is possible to share a disk between two AS/400 machines. I know about DDM but I would like to know if it is possible otherwise. Thanks.



Answer Question   |  December 13, 2012  9:49 AM
AS/400, DDM
asked by:
80 pts.