Using a CL program, I want to pull a packed date field from a file and pass the date as 3 fields; &MM, &DD, &YYYY to another CL program. I am able to get the date field from the file, but am ...
How to convert decimal to ASCII -need math formula
I am having a problem connecting to my 820 machine. I am getting CWBLM0031 RC1=2 and RC2=21. I checked the Work with License Information but I am not sure what to look for. I was reading othe...
Dave Slater provided some code for sql in VB macro. I have tried to use this code in my macro but can't seem to get the sql statement correct. I have attached the code if someone can tell me...
We have a VB app that puts a text document in a shared folder on our iseries, then an as400 application wakes up and processes that text document. The problem is that job QZLSFILE for user QU...
I need to mass update user profiles in the AS400 programmically. What is the name of the file and library in order to do this?
I am using the i Series Access for Windows cwbx.dll module to make remote calls to an AS400 machine for the first time. I have posted the code below as to the method I am using. The jist of ...
How do you program (RPG) OCR A print on an IPDS printer (IBM4234 Model12). Can you program the code within the RPG program or do you have to use a printer file? Any samples anywhere?
USBOBL
Continuation of question:
http://www.experts-exchange.com/Programming/System/AS_-_400/Q_23778490.html#a22620089
@Tom - Thanks for answering with a question. Let's me layout the whole pictu...
SYSTEMS HOST: AS400 DB@-400
TARGET: UNIX Oracle MDM DB
I am trying to connect to a Electronic Data Warehouse DB on a UNIX server using embedded SQL statements within ...
Hello -
I wondered if someone could assist. I'm very much a beginner in programming but need to create a simple script/macro to enable passwords for a large list of profiles later this mo...
n Crystal Reports 2008 how can I define a numeric field from the AS400 which is a 'date' and I want that fiedl to be edited as a date? Please let me know.
I have a notebook connecting to our iSeries via iSeries Access over our LAN. The connection can be established but after 3-6 minutes it drops, reconnects and is ready for sigon again. Any idea...
I have an Excel Spreadsheet using Get External Data and an ODBC Connection to an AS/400 database.
I have the spreadsheet set to refresh the data every hour. When I deploy this spreadsheet to...
Option 1:
CALL QCMDEXC('SBMJOB CMD(CALL PGM(T_SESLIBWL/CNSHPPUC)) JOB(PROCNEWEDI) JOBQ(QB
ATCH4) MSGQ(*NONE) INLLIBL(T_SESLIBWL)' 0000000103.00000) ;
Option 2:
CALL PGM(QCMDEXC) PARM('...
Hi Friends
I'm using PCML to connect As/400. PCML is calling a CL program with some parameters (e.g From-date and To-date). I'm validating the dates in CL program. If the date validation fail...
i am new to the as400 and i need to know how to run queries and also various commands i need to do this
if i wanted to connect a as400 to a emc device what questions woudl I nee dto ask to make sure it was successful
We have a number of different PC's set up with a Zebra 105sl Label printer connected via Parallel port. On these PC's we have an as400 print session and an as400 work session. These are for ou...
Does anyone know how to retrieve the HOSTNAME field from TCP/IP in a CL program? The field is the HOSTNAME field if you do a CHGTCPDMN-F4. It seems like you should be able to retrieve this to...
I have the the following variables in RPG
D @52 S 80
D @53 S 80
D @54 S 80
Those variables can be filled with any...
Hi,
My issue is, I have a Subfile whose page size is 19 and use a "Load a single page at a time" type. I am displaying a set of Item Records for a particular Master Item. I also have a fiel...
We need to move files from the IBM i5series server to a Windows 2003 server. The requirement is to exeute a ".bat" file on the windows system. The destination directory is shared on the Windo...
When building a Logical File Definition using DDS ...
... SST is the SUBSTRING function
0009.00 A WHOOWNS I SST(TLTBLS 26 5)
That's great ... but ...
I ...
I have very little experience with this so I hope someone can help:
I have just installed a new laptop for someone on the accounts dept who uses bespoke software from a company called GEAC ...
