Hi
i am asking behalf of my friend.
What is the ascii code for the carriage return in AS400?
charachter=13??? or ??
i dont know what exact thing my friend looking for...but sort o...
Hi all, I have a quick question about the syntax for an SQL statement I am writing. I need to know how to do an UPDATE statement such as:
UPDATE U269672.MYFILE SET [Date Created] = .....(...
I am trying to create a stored procedure using SQL/400. I need to compare a date that I have converted to a character using the character function: CHAR(YEST2,ISO) (character version of yeste...
Hi
Where an I download AS400 OLE or ODBC driver for
doing development work for VB to connect to AS400.
Is the OLE ODBC Driver suitable for all kind of AS400 server/client connection ?
...
In Free Format any ideas on how to Convert a Date text string to CCYYMMDD Decimal
Eg 'March 2006' -> 20060301
Lenght of date varies depending on Month Value
Eg 'August 2007' -> 20070801
...
I've just got a job on AS/400 RPG Programming. Actually all my experiences go through SQL Server, And Windows Base Programming. So I wonder...
If there is any AS/400 Simulator for win...
I have a spool file from the as400 when it is copied to a physical file for pc manipulation, it loses it format. How can I get the spool file to the pc without losing the format. I will post a...
Hi I have to format date to the iso 8601 format. I'm using AS400 who returns the date to the format "yyyy-MM-dd" and time as "hh:mm:ss".
How can I in VB or C++ get my date as the ISO 8601 f...
Hi,
Simple follow-up question.
If i take the decimal number 98 and pack it into 1 byte i understand that:
9 becomes the firstpart of the byte (1st nibble)
8 becomes the second part of ...
Is there a simple way to call an AS400 (RPG or CL) program from a C# program? I would simply like to call program, pass parameters, get return values. I am using OLEDB to access the AS400 da...
As of Now, I am using CPYTOIMPF to first get .csv format file from AS400 physical file and then I am using CPYTOPCD to convert it to document (which will be in csv format). I am mailing this c...
Hi all
I need some step by step guidance on this one.
I have got to the stage where I see the iseries add on in Excel.
Could someone please give me some instructions how to transfer ...
Hi Guys,
I am trying to get IBM Client Access V5R2 5250 to work via the internet using VPN. I have configured the VPN Appliance to allow the following IBM Client Access Ports through to my ...
I'm studying about AS/400 System.
Comparing to Windows, it's hard to find some information about AS/400 on Internet.
Although I've some documents from IBM site, it's also difficult to unders...
Anbody doing SQL in a CL on the Iseres?
thanks in advance,
Don
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...
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've just got a job of programming RPG langauge on AS/400 platform. What is the most obstacle I've from getting my job is that I cannot pratice RPG programming on standalone PC. Sin...
How can I declare RPGLE array Data structure?
How can I use in side the RPG PGM?
TIA-MW
OK, My eyes are getting tired from reading through EE. It's very informative with suggestions but I need a step by step to connect to our AS400.
I did get the DATA Menu>"Get External Data ...
I have a program which gathers user information weekly for 3 companies. 2 of these companies reside on the same iSeries AS400 (v5r3) in 2 different libraries. The 3rd company is on a remote ...
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 ...
Is there an easy way to create a timestamp field from a date and a time field?
I'm currently converting both the date and time fields to character using %char and then appending them together...
Big points for this, so ya gotta do some thinking!!
I want 30 questions that would most likely come up in an interview that programmers and managers ask potential new RPG programming employ...
All,
In advance, thank you to anyone who can help me out.
I am attempting to create a "cdp" file (Connect:Direct process) that will transfer a log file from an NT server to an AS400 serv...
