• How to use API to access DB2 file on iSeries

    Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he's searched the IBM manual, but he couldn't find the APIs that he can use. Can you help him? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • Good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utility commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • Calling a URL length more than 200 from CLP

    Hi Techies, I would like to call a URL by passing some input values and retrieve some values from the results. The URL lenght is more than 200, with special characters like % " < / > I need to retrieve values from the particular website. Can you please help me out soon, its been getting...

    as400dev480 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • Convert XML to DB2 file

    We still use the command to convert DB2 file to XML (RUNXML) and need a verse option to convert an XML document to a database file.

    UWeber5 pointsBadges:
  • Create DB2 table relations

    There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might...

    Toramky5 pointsBadges:
  • DB2: Optimizer not using any indexes

    I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?

    AS400 - Ask the Expert485 pointsBadges:
  • Is the new WRKDBF out yet?

    Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

    Yorkshireman5,580 pointsBadges:
  • is there any process to store the data of dataqueue

    is there any process to store the data of dataqueue

    Siru15 pointsBadges:
  • DB2 data over web browser

    Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..

    bsathia20 pointsBadges:
  • Set up DB2 Web Query dashboard

    I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?

    Piano520 pointsBadges:
  • Download from the AS/400 tab delimited file

    I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so that it will run unattended. Any...

    Butcheanes5 pointsBadges:
  • Connect to DB2 of V5R1 from .NET application

    Hi all, I want to connect to AS/400 DB2 from my .NET application. I just want to know which are prerequisites for this connectivity and data retrieval.

    hunshabbir71,915 pointsBadges:
  • SELECT AND OMIT in RPGILE

    hI,GUYS,Actually select and omit used in lagical file to control the records,values like. But without key field how can i use these select and omit condition in logical file? And one more doubt is what is the exact uses of %SCAN,%SUBST, %SUBDT,%EOF,%CHECK,%COMMIT,%FOUND.Plese explain these

    abhisheka1385 pointsBadges:
  • DB2 User Password creation

    Hi, I am new with this database administration. I have installed DB2 Express C.Now I want to create a user & to assign password for this user through Data studio. I can create an user, but unable to assign the pwd. Please let me how to assign the password for an user created through data studio.

    HABBIE845 pointsBadges:
  • Member relationship in DB2

    I would like to know the relationship of member in DB2 interms of  MSSQL table. I need the query to fetch member in SQL Server

    sbesuedbknk5 pointsBadges:
  • career advice

    i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met a friend who...

    Haller80 pointsBadges:
  • Null dates coming in as 2001-01-01 SQLRPGLE

    Our SQL statement is literally trying to put '0001-01-01' into a field and it's still coming back as 2001-01-01... Any ideas?

    Dcantwell470 pointsBadges:
  • CPYF in arrival sequence

    Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can't find a native os/400 command that will do it.

    Dasturg0 pointsBadges:
  • Sending email attachment from mainframe – MIME format

    Hi, I need to email 2 flat files from mainframe as CSV files. (the data in the flat files already contains the delimiter ','). The problem is, i get the 2 files attachements as CSV, but nothing in them! I feel I've got the MIME formatting wrong. I use IEBGENER, and the flat files are FB format....

    Dannymit0 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