AS/400 Database Questions and Answers

Recent IT Questions

1 - 20 of 36
<<PREVIOUS 1|2 NEXT>>

UDS and DS

I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this? Software/Hardware used: Iseries

View Answer   |  Oct 27 2009  2:23 PM GMT
AS/400, Data structures, AS/400 database
asked by Kar

  95 pts.

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

View Answer   |  Oct 26 2009  10:42 AM GMT
AS/400 database, DB2/400, i5/OS
asked by R.otto

  435 pts.

Member Level ID

Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and...

View Answer   |  Oct 22 2009  3:43 PM GMT
AS/400 database, AS/400 development, iSeries database
asked by Wpoulin

  1115 pts.

query/400

plz tell me how to work with query/400 on as/400 machine...thanks Software/Hardware used: as/400,IBM i

View Answer   |  Oct 6 2009  1:22 PM GMT
AS/400 database, iSeries
asked by Ten2008

  705 pts.

Bad data in as/400 database.. cant display record

We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...

View Answer   |  Sep 4 2009  5:58 PM GMT
AS/400, Hex, DFU
asked by ToddN2000

  175 pts.

client access 32 bit ODBC drivers

where can i download 32bit client access ODBC drivers onto my windows(XP) system so that i wanna migrate my access files to AS/400 files.Plz guide Software/Hardware used: as/400

View Answer   |  Sep 1 2009  8:31 PM GMT
AS/400 database, Client Access
asked by Ten2008

  705 pts.

MS-Access data access

I wanted to access a MS-Access database file on my PC to my AS/400 and want to convert it into a physical file.Can anybody give me the steps in this process and requirements for that? thanks Software/Hardware used: as/400

View Answer   |  Aug 31 2009  6:41 PM GMT
AS/400 database
asked by Ten2008

  705 pts.

What is Database Pagefault in AS/400

What is Database Page fault in AS/400 it is releated to WRKACTJOB plese send the answer if any one knows

View Answer   |  Aug 6 2009  2:14 PM GMT
WRKACTJOB, AS/400 database
asked by VenkatPemmasani

  35 pts.

How to export meta-data

I am charged with archiving data from a legacy AS400 packaged system. I can export the data using attachmate and a few tricks to get it into XML on my LAN. However, the FDF info is not good as metadata, so I need to retrieve the field level that is available thru 'file commands''display file field...

asked by TP07830

  5 pts.

What causes the last used date to be updated on a file?

I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is...

View Answer   |  May 28 2009  5:36 PM GMT
iSeries database, AS/400 database, DSPOBJD
asked by CLKelly

  65 pts.

Rebuilding Logical Files

What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?

View Answer   |  May 27 2009  4:57 PM GMT
iSeries, Database maintenance, Rebuilding Logical Files
asked by Dcantwell

  165 pts.

whats are the contents of a databse fields after the record is written

I have a field in a file eg. NewQueue. Once I write or update a record in the file that has field NewQueue, are the contents of that field still available for evaluation?

View Answer   |  May 20 2009  7:04 PM GMT
RPG, RPG Data Fields, AS/400 database
asked by Macitmich

  15 pts.

I am not a programmer

I am a buyer and we are looking for a way to run AS/400 data reports to a PC. The AS/400 is located in Guinea and connects to our network through a server in an office across the street. What are your suggestions to accomplish this? Thanks.

asked by Gordon24

  5 pts.

Is a DB on AS400 always DB2 ?

Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely

View Answer   |  Apr 7 2009  3:25 PM GMT
DB2, AS/400 database, RPG
asked by Poussines

  35 pts.

Packed Data

How do I display a packed data field on the iSeries?

asked by Plaporte

  40 pts.

Maximum number of records that can be stored

What is the Maximum number of records that can be stored on an as400 data file.

View Answer   |  Mar 30 2009  12:19 AM GMT
AS/400 Records, AS/400 tables, AS/400 database
asked by JohnsonMumbai

  380 pts.

How to Determine Database Access on AS/400

I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.

View Answer   |  Mar 5 2009  3:36 PM GMT
AS/400 database, DB2/400, DB2
asked by DaCurryman

  5 pts.

DB2/400

WHEN ACCESS PATH WILL BE CREATED AND WHEN OPEN DATA PATH WILL BE CREATED?

View Answer   |  Jan 24 2009  6:06 PM GMT
DB2/400, AS/400 database, AS/400 DB2
asked by TNKR

  5 pts.

Native database implementation on AS/400

Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.

View Answer   |  Dec 22 2008  2:32 AM GMT
DB2, DB2/400, AS/400 database
asked by Engineerteja

  5 pts.

How to get the row count of a PF with RPG ILE?

Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.

View Answer   |  Dec 10 2008  2:10 AM GMT
RPG, RPG ILE, RPGILE
asked by Mariodlg

  210 pts.

1 - 20 of 36
<<PREVIOUS 1|2 NEXT>>