These days with iSeries bach machines (0 interactive), and even developing RPG code but without green screen (i.e. doing html screens) would be nice found any Windows PC Editor program able to...
Can we retrieve the DSPF source form that Corresponding Object?
TIA
MW
cant locate where to use EDTMSK() !
cant find it in SDA untility nor works in display file code.
Since i have heard it can be used for masking letters, date seperator validation etc....ple...
Hi,
I'm trying to create a connection between an as400 mainframe and asp.
The webserver (NT4) is running IIS and Client Acces.
I already created a connection to the disered as400 th...
I would like to automattically send an email from our AS400 (ie. Customer Quote) that is formatted in HTML. We already send spool files and PDF attachments currently. SNDDST currently works ...
AS/400 Logicals Question:
I have five PF that I want to join and they all contain a key! When I join them I only get the records that match in all of the files instead of all records whethe...
This is exactly what I want to do, BUT
I need to divide by a number WITH 3 decimal positions. I cannot truncate or lose these posiitons.
ALL of the standard documentation shows whole numb...
How can i get the number of records in a file in CL PGM.
Hi,
on my AS/400, i want to reduce the Usage count for a specific Product (WRKLICINF). For this, I have to delete some License users. A lot of this as has been deteted ( DLTUSRPRF) but the ...
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 ...
Hi,
Anyone can please provide me the information for AS/400 system operator Certification details like course materials, and past sample test papers for practice ?
Thanks in advance.
We have several applications that need to send printouts to customers via fax and email. The best format to send to them is to convert the document to PDF and then send. This in not an issue. ...
i have a cl program that once retrieved a number from a data area, *dec 7 0. Now the CL needs to pull that number from a different data area of type *char 7 . How do I get the new char data ...
I have an eight character number field that I need to convert to a date in a query I'm putting together. Example 20040105. What is the exact syntax that I need to use with the Date function....
Hi,
I'm hoping to use the MONITOR and ON-ERROR op-codes to test for writing a record with a duplicate key.
In the manual, it says the "factor 2" of the ON-ERROR op-code is an "exceptio...
Hi experts,
I created an SQLRPGLE program that is creating som output, with a variable selection and sorting. The string it has build to execute the SQL is :
SELECT * FROM ORDDTLS1 WHERE...
Our 400 has recently slowed down quite a bit since installing a new Java application server. Our server only has 256mb of RAM (model 250). We are looking at adding another 256 or 512. I com...
I need to know how to go about mapping a network drive from my AS/400. I already know how to map one to the AS/400.
How do I call a program on the AS/400 from Visual Basic?
I've tried the following:
In the Declarations section of a Form:
Dim cnnAS400 As New ADODB.Connection 'Done at Prog...
Can anyone help me with the steps to add a hardwired (TwinAx) printer to an AS/400? I can add one using TCP/IP protocol, however, have been unsuccessful when trying to add one that is hardwir...
Hi
I want to know what is the purpose of DataQueue.
How to use it in AS/400 & RPG/400.
If possible, give source code on the usage of DataQueue.
What is the difference between DataQ & O...
Hi ,
iam trying to FTP a file to main frame. It is giving me the following error.
550-SVC99 Return code=4 S99INFO=0 S99ERROR=38668 HEX=970C S99ERSN code
X'000042CE'). Unable to create da...
Currently i have my AS400 sending emails from RPG programs and have also tried the sending test email using the command
SNDDST TYPE(*LMSG) TOINTNET(('jdwan@jdmpartners.com.au')) DSTD('TE...
Hi,
I m a vb6 programmer. I have started a new job where they have main software running on AS400 and I have no previous knowledge of AS400. After trying I have been able to access the AS400 ...
Dear / Expert
I create a cl prog to get some files from a pc server , i create a src member on a source file put in it the ftp command ... the user & password and the name of the file that ...