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...
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...
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
...
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 ?
...
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...
update library/file set substr(field1,13,3) = 'XYZ' where
substr (field1,13,3)= 'ABC'
My hope is that this SQL would update a portion of a field, but it does not work....
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...
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 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 ...
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...
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 ...
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 ...
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...
How do you program (RPG) OCR A print on an IPDS printer (IBM4234 Model12). Can you program the code within the RPG program or do you have to use a printer file? Any samples anywhere?
USBOBL
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 it possible to write to a database physical file within a CL program, using data created through a variable e.g. current date value. I wish to write the &MSGDTA variable to a file for futur...
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 ...
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...
I am new to AS/400 platform.
I issued the following command after reading a brief online tutorial.
>DSPLIB QSYS
I just want to familiarize with the OS and its file system and basic commands...
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...
We are currently running a project to upgrade all our 95 pcs to XP but I need to resolve a mapping issue I am having, detailed below.
I am trying to map a drive on my XP pc to folder QDLS on ...
Anbody doing SQL in a CL on the Iseres?
thanks in advance,
Don
