• UDS and DS

    I know well Data Structure (DS) and its usage, how is UDS (Data Area Data Structure) 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 explaining this?

    Kar425 pointsBadges:
  • 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.

    r.otto810 pointsBadges:
  • How do I connect to AS/400 Database from Visual Studio

    I would like to connect to AS/400 DB from .Net 3.5. Can anybody help me with this?

    SriramM5 pointsBadges:
  • Is it possible to get an alert when database page faults exceeds a certain amount.

    Is it possible to get an alert when database page faults exceeds a certain amount. Iam referring to the page faults which appear when we give the WRKSYSSTS command.  Or write a pgm which could monitor the page faults and sent an alert. 

    JohnsonMumbai1,160 pointsBadges:
  • How to run query in AS/400?

    New user, like to know in detail how to run query in AS/400 with snapshot will be better.

    Shreekant40 pointsBadges:
  • Creating a AS/400 database

    Hi, Till now I have worked as a Developer & recently I got a task on creating a database on AS/400. Can any one please let me know, what are the steps to be taken before I start creating database on AS/400 server.Is there any kind of tools so that I can connect with my server & to create...

    HABBIE845 pointsBadges:
  • AS400 database

    Hi,I have some kind of database, tables are from SQL server around 10 tables each having 1000 records. Now I need to convert these SQL tables into physical files & i need to store the same SQL records into these created physical files & finally should make the database as db2/400 database...

    HABBIE845 pointsBadges:
  • Connecting to a AS/400 database

    Hi, I am new to the database activities on AS/400. What is the difference between DB2/400 &DB2/LUW. What is a federation server? How can I connect to a particular database using tn5250 terminal? Is it possible to see multiple databases using this emulator tn5250. Kindly help me out

    HABBIE845 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • AS/400 via Access, update query

    Hi all, My DB is on AS/400 and I use Microsoft Access to run queries. However, whenever I try to run an update query, I receive the following error message: "[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 - table in library not valid for operation. (#-7008)" Any idea what is missing? Thanks in...

    Antser5 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 pointsBadges:
  • Convert data to character string in AS/400 query

    I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can't see how to convert the temperature to a character string either as the sign is ignored. Any other...

    Jubal5 pointsBadges:
  • Access path and open data path in DB2/400

    When will an access path be created, and when will an open data path be created?

    TNKR130 pointsBadges:
  • Migrate application from UNISYS to AS/400

    How can we migrate an application currently running on the UNISYS platform to AS/400 platform. A major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database.

    126170 pointsBadges:
  • IBM Linked server will not do inserts

    I've spent close to 2 days looking for an answer and only got a headache. We have our IBM DB2 linked server defined as IBM DB2 UDB for iSeries OLE DB Provider. We can run select, update and deletes we just cannot do an insert. Here are our sample statements. SELECT * FROM OPENQUERY(OUR_DB2,'SELECT...

    ToddN200015,080 pointsBadges:
  • File in external datastructure

    Will level check occur on program when you changed the file mentioned in external data structure?

    Kvrs8070 pointsBadges:
  • Is it possible to increase the length of an existing data area

    Dear All! Is it possible to increase the length of an existing data area, without disturbing the values in it? For instance, I have a data area with initial length of 256 with some values already in it. Now that some more fields need to be added to the program (due to enhancement) which writes into...

    svankipu620 pointsBadges:
  • AS/400 / CF DESC

    Hello I am trying find a way to change the Customer Friendly Description in the SKU (SKN) DESC. 

    AFNAN1198910 pointsBadges:
  • Connection String for AS/400

    Hi all. Here I'm using iSeries Server. I just want to connect VB.NET with AS/400 database. Simply I want to retrieve some data from a PF on VB.NET. Anybody can you tell me what is the connection string should be used? If you have any simple sample code in VB.NET please post here... Surey

    Sureyz2,475 pointsBadges:
  • database

    if i have one pf (pf009) and one logical file (lf009) on pf009. how we can add one more field after compalisation of logical file ?  

    anupsshelke420 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following