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 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...
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...
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...
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 ...
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...
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
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 ...
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 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 ...
How can I declare RPGLE array Data structure?
How can I use in side the RPG PGM?
TIA-MW
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 All
Got an interview for an ERP company where I'd be based at a large client. It's a desktop/lotus notes/as400 Now the windows and notes part will be a walk for me. But I haven't work...
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 ...
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...
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...
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...
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...
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...
HI
I have users connected to an as400 through terminal servers (application jdedwards), in the as400 for each user it generates a job QZDASOINIT user QUSER subsystem QUSRWRK. Is possible to ...
