I keep getting "Record in file QSYSPRT truncated at end of line." after I change date format -- I change it from 6 to 8 digits. Even I change it back, I'm still getting this "Record in file Q...
I am into an IBM AS400 in the Query Utilities for DB2. I have many options but primarily before I can use the Query Manager and Utilities I need to know how to locate the tables in the databas...
In RPGLE you are able to pass a pointer (i.e. an address of a Data Structure) between 2 RPGLE programs. Are you able to do this, but having a CLLE program between the 2 RPGLE programs. So - I ...
Citrix Presentation Server 4.5
IBM Client Access 5.7
WYSE V90 Thin Clients with Windows XPe
I am able to 'push' the application to the end user with the pcsfe.exe file. I would like to ha...
I have one last item in my school project for an interactive display system for working with customers files and ordering files. The only thing I can't figure out is how to convert the system ...
My client uses a tool retrieve COBOL source with a object.
In CL we have RTVCLSRC to retrive the CL source from object created.
Please let me know if there is any tool to get the COBOL sourc...
Hi:
I am using the CPYSPLF utility to copy a spoolfile to a database file.
Could anyone help me with sample code to replace the following code to use
the QSPGETSP / QSPPUTSP APIs instea...
IBM, Iseries Access for Windows, v5r3m0, PC OS Windows 2000 SP4, IBM , Iseries, 9406-270, Entry point not found for CWBCKVER.EXE, CWBINHLP.EXE, CWBSVSTR.EXE, CWBWLWIZ.EXE, Problem started after movi
After deleting IBM Client Access from a Windows 2000 machine I tried to do a reinstall. When configuration buttons are pressed on the config screen nothing happens. When booting the machine af...
Hi Experts,
I have the following issue:
Running a SQL command on the AS/400 will select a record within less than a second.
When I try to get the same record (with the same SQL) via ODBC,...
How do I Select records on based on the variable of todays date compared to going back X amount of days,months, or years. I know it has something to do with creating a field and expression but...
I am trying to get the month number of a date in AS400 DB2. by using the function I get a return of 1. I need it to be '01'. Any ideas on how to do this? Here is what i am using to return a MM...
I need to e-mail an AS/400 spool file to a specific e-mail address as an attachment. Any idea how I achieve this. AS/400 V5R2
We are using an AS400 i570 box with i5Os V5R3. We are using MIMIX (Lakeview) to replicate between partitions & between PROD & DR box. Need assistance if a script can be configured to give me t...
Hi,
I'm working on an AS400 DB2. I have two dates, START_DATE and CURDATE(). I need to know how many months there are between these two dates. Currently I'm using (CURDATE()-START_DATE)/...
I created an SQL cursor on my item master(IM), opened and fetched the first record. Now I want to process that record in my inventory transaction file(ITH).
I create a second cursor where ...
Does anyone know a good AS400 architecture free tutorial...a kind of AS400 for dummies, describing the architectures, briefly the operating system and its components, databases used, transacti...
Here is my code:
C *LOVAL SETLL CST280PL2
C READ CST280...
I am currently developing a CGI program (using RPG) which will output an email which contains a URL to another program which allows the user to click on the link to easliy access the program. ...
I'm using RUNRMTCMD to run RTOPCB on a PC that isn't on the same network, to pass an AS/400 file to a PC. I'm using the following command values: RUNRMTCMD CMD ('c:\edi\company\EDI2PC.BAT') R...
Hi there, i have just copied our live data to the test environment and as part of the process, and renamed the libraries as necessary during the restore. I have been told to delete the logica...
Hi...
I have an as400 program that I can call it directly from asp.net and it works:
variable= "xxxx"
sql = "CALL METSIGOP.SIGOPRC ('" + variable + "')"
Dim con...
Hi,
I am prashant here. I have one new requriment. I need to download the AS/400 spool file into Excel. But I can not use any tools even if it is free. I need to use either CL or RPG langua...
Hi All,
I am planning to take i5 iSeries RPG ILE Programmer (IBM Test - 268) exam since last few days. But I am not sure whether it will help me into my career and what type of question I n...
I am writing to a file containing variable length fields via a trigger program. I keep getting a data mapping error on the first variable length field in the file. They are not all variable ...
Here is my code. I want to clear the physical and hence, all logicals, all members of both. This is not user specific. I want them all cleared irrespective of the user.
This is a multipl...
