How do I delete an file on the ifs drive from a cl program on the as400. I use a cpyfrmimpf and then I want to delete from the ifs.
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 ...
Hi
We have created our own subsystem (for a range of ip addresses) This is same as QUSRWRK (ODBC/JDBC calls to iseries using PCML). When PCML calls rpg program then the first job QZDASOINI...
Hi All,
Does anyone know how I can get the account creation date for the user profiles within AS/400. Does AS/400 store this information?
How do I add or subtract incremental units in AS400? The value 107009 equates to 1/9/2007. I want to subtract 40 days to get 12/1/2006.
Just FYI, I am trying to create a function that wil...
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 am attempting to Add a column to a table.
I get this error: Connectivity error: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0913 - Row or object CONSUMER in BASI t...
Hello,
I am trying to run the following batch file from a CL program on the AS400. The batch file copied a text file to the iSeries IFS and then I import it into a database table. The pro...
I have written many subfile RPG programs. I have a need for a program to one of the following: (1) write out an extended sub file record (record 1,2,3 my be extended - taking up 2 lines each...
I have a file that has records that only contain dates in julian format. (i.e. 2006082).
Can you, using Query, create a result field for the julian date and have it contain the
MMDDYY equi...
Hello:
I am working for a company that has an international country (Turkey) setup on the 400; It has specical code-page-settings on the file at the field level (JDE F0101) (code page 37) s...
Hi,
I would like to implement triggers in AS400 Database.
For example I have 5 differnt libraries in AS400,also I would like to trace particular tables from different directories.
Is there...
I have done the add-in for Excel to extract data from AS400, using cwbtfxla.dll as the add-in. This works well on some machines, but on others I get the message: cwbtfxla.dll is not a valid a...
Hi,
I'm a newbie who knows nothing about AS / 400. I'm a fresher having an opportunity to work on AS / 400.
I want to know more about AS / 400, the technologies it supports, broadly what...
I am using the ISeries File System to allow objects in the File System to be viewed by Windodws.
I can create files on the ISeries and view them through Windows Explorer, using a mapped net...
I have a user that recently complained of slow system performance. I removed PC-Doctor and all of the proprietary Lenovo software from his laptop. Then, I-Seires would not start. I opened cont...
We are in the process of sending emails to our customers but has come to a halt due to an MSF stopped processing messages as per example below.
We are running OS V5R3.
**SMTP distributio...
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 ...
I was trying to access Management Central in iSeries Navigator and received the following error: failed to connect to central system 'Iseries.istate.com'.
After clicking on Verify Connecti...
I'm trying to write to files on an iSeries using DB2 connect with PHP (using the pecl ibm_db2 package). I can write successfully only if the file I am writing to is journaled.
It appears tha...
I've been updating some old RPG programs to SQLRPGILE. This particular program is not giving me the same results as a runsql would.
When I run the statement in an Interactive SQL session (...
I have an iSeries model 520 that has an HMC and 2 partitions. I want to be able to send files between the 2 systems, and cannot get it to work. When I use Management Central in iSeries Navigat...
Hello,
How do I, or can I assign a menu to the attention program (escape key) of a user profile on my AS/400? - see attached - userprofile.jpg. For example, we have some some custome menus th...
What is BPCS on an AS400 system?
I am trying to print to laser print a AS400 report that is 198 characters long on a 8.5x14 paper. The problem is that its only printing landscape at 8.5x11. The printer is HP LaserJet 2200DN...
