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...
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 ...
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...
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 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...
I have a feeling I am not going to like the answer but I am going to ask the question anyway...
We have a mixture of printers here, for the most part, the "IP" address shows up with I do a ...
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 ...
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...
i am new to the as400 and i need to know how to run queries and also various commands i need to do this
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...
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...
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...
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...
I have an AS400 file. This file has an external descripton on it. I created a cpytoimpf to send it to a ahared drive that the PC user can acess to get the CSV file. My only problem is that ...
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('...
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...
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...
Per DOCs ....
I quote
"You should avoid using the REFRESH TABLE statement to update user-maintained materialize query tables."
and again
"Use insert, update, delete, or lo...
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...
In preparation for a softare upgrade, I need to search all files / libraries on my AS400 for a certain string. This string could be contained in CL and / or RPG programs. I used STRPDM to s...
