DB2/400

content of source physical

hi all, can any one plese tell ,how can we see the content of any source physical

how to access any perticular menber of any pf

Hi, if i have a pf having 5 members..how can i access 3rd member of it through in rpgile.. regards Ambrish

db2/400

Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?

External DB2 Database link/trigger

In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4

SQL error

I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

system storage

Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP('/') NOW I AM...

Diff. between PF and a sql table

can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

CPYTOIMPF data corruption

CPYTOIMPF on V5R4 with latest PTF's adds invalid data to the created CSV file for some blank fields in the PF. Is this a Bug? Software/Hardware used: AS/400 V5R4

DB2/400

When we do DSPFD for a file it shows physical and logical reads. What is the Difference between physical and logical reads?

DB2 connection in VBscript

I need to delete some records from a DB2 database on an AS400 using VBscript.

Delete OLD files from Table not having date or timestamp

Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

DB2/400

I have created one Physical File with 1 key field. After that i added some datas in that file. Records in file are displayed in Arrival order While Viewing the Records using DSPPFM, STRSQL Commands. As per my assumption, it should be ascending order. Why it is not displaying in Ascending order?

Launching AS/400-iSeries with DB2 and RPG

I am new in AS400/ iSerices. Actually I am a software developer C#.Net in my office we have database on AS400/iSerices DB2. I usually use Sql. I want to install or launch AS400/iSerices on my home PC. Can anybody help me how launch AS400/ iSerices on my personal PC. Thanks in advance. Mr.SEA...

File attribute DFU

I have come across an object whose type is *File and attribute is DFU? What does this mean?

Flat file to PF conversion

Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

Certification sites for Synon?

Hello, Please can anyone suggest some good certification sites or courses for Synon or DB2 400. Except the ones from IBM. Synon is more broadly needed!!

DB2/400 - Source Physical File Deletion?

I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted....

How to connect to an AS/400 database from a remote PHP script

Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

Transform DB2 to XML from AS/400

I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...

AS/400 data mapping with CPYFRMIMPF

We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new...