Here is my code:
Dim cn As iDB2Connection = New iDB2Connection("User ID=yeah;Password=yeah;Data Source=10.1.1.999;Connection Timeout = 0")
Dim cmd As iDB2Command
Dim sqls...
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...
Is there an RPG Length function? I know there is an RPGLE %LEN( ) function but I'm not sure about RPG. I have several old RPG programs that I need to determine the length of a field and then...
How to convert decimal to ASCII -need math formula
I am having problems witgh passing of variables to a CL program. The variables are as follows
parm1 = '1' (possible 11 long)
parm 2 = '070808' (possible 6 long)
parm3 = 'This is a test ...
In OS/400, what messages are sent to the QSYSOPR message queue but not to the system history log QHST?
I am getting an error MSG CPF4207 with reason code 6 (User ID not valid. For a iseries server this could mean a damaged user profile or PASSWORD(*NONE)) . But when I check to User Id in the r...
What is the different between OPNQRYF & WRKQRY ?
Can i use the query definition i created using WRKQRY in my RPG program like i use OPNQRYF ?
I have an AS400 system that will automatically disable user accounts that havent logged in for a certain amount of time. This causes obvious issues as you can imagine. I would like to know whe...
Here is the code I've created. The problem I'm having is upon execution, I get and "unknown error" error message just after my message box for "about to write to dq". Not sure what I'm missi...
Hi All,
I am encountering the following problem when trying to send a network file from our site to a customer remote site.
I can send the network file across to the customer' machine, b...
I'm working on an application to assist in the changing of passwords on our system. We are a mixed windows and AS/400 enviroment. I got the windows part down. However I would like to encorpora...
Windows Logon credentials are unavailable error message coming up when attempting to connect to iSeries server.
This has never come up before, and it as always prompted for credentials inst...
I was recently hired into a AS/400 and windows server 2000 network enviroment. We currently use the IBM i series access program to access the AS/400 remotely. There are devices that are local ...
I have an iSeries RPG program that writes a report using a printer file that has a dozen different record formats. I need a way to repeat the printing of each page, without having to read thr...
Hi Guys,
I have 2 PCs out of 200 that will not connect to my AS400's using 5250 Emulation. When i try to connect, i get the following error message:- Remote Address Could Not Be Resolved. ...
The user transfers spool files to their PC via a Client Access File Transfer (DTF) that runs invisibly, but I have to use STRPCCMD to fire it off. Because of STRPCCMD it pops up the PCO sessi...
I am having a problem with my asp page not connecting to the AS/400. When I go to that page I.E. seems to try to connecto, but eventually does nothing. My timeout is set to 30 seconds but it...
I have set of SQL statements to accomplish one process, which reverses one particular transaction in our system. There are 5 different SQL to complete this all accept the same parameter. Now w...
I am in need of a a query deifnition in the AS/400 Define Results Fields that will format an existing field to a date format. The existing field has data representing an activity date and appe...
Hi,
I have the following code, Basically what i'm trying to do i have already a query defined which generates my output file in iseries/as400 which i further go ahead and import into excel ...
I have a keyboard that has a F1-F12 function keys.
I want to display more function keys buy using F23. I think there are combination of the F12 function key and the SHIFT key. What are the ru...
HELLO
I`ve got a db file A (compiled) it has some records every record is one file (library, type of file and filename).
I know how to read this file (i define him in the first line of t...
Hi Everyone,
I'm looking for an example of a script used in AS400. I use the macros all the time, but I'd love to figure out the scripting capabilities, as it would save me quite a bit of ...
I need to create a md5 fingerprint from within a RPGLE app. I found some good sample code at http://bb.blackrobes.net/viewtopic.php?t=9 .
The only problem is that the example is coded to us...
