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] = .....(...
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...
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...
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 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...
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 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 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
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 ...
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 ...
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
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 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'm trying to use two WITH statements as below:
WITH intraco as (SELECT ltowh, lprod, sum((lqord-lqshp)) as toship, sum((lqshp-lrqty)) as toreceive, sum(((lqord-lqshp)+(lqshp-lrqty)))...
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...
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 have shared folders set up on the iSeries, two of which users in our accounting group are supposed to have access to. One is called CONVERT which is mapped to J: on the users PC. the other ...
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 ...
