• Version of DB2 running on AS/400

    I need to know the version of DB2 running on AS/400, do you know how can I to get it?

    GeLaLo10 pointsBadges:
  • SQLCBLLE not running correctly and does not produce MSGW

    I have been facing this problem lately: normally when there is a PGM ILE COBOL running on batch and triggers an exception it makes the batch job stop get go from RUN to MSGW, but when it is a SQLCBLLE and there is a problem executing an SQL statement it simply rolls back and continues execution...

    hamzahir60 pointsBadges:
  • DB2/400 database on Windows

    Hi, DB2 c express database can be installed on any Windows, Linux etc. We can develop using DB2 c express. My question is I need to develop procedures & functions only on DB2/400 database alone. Can someone tell me where can I get DB2/400 database which can be installed on Windows as similar as...

    HABBIE845 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:
  • 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:
  • Connecting to more than one AS/400 DB2 Remote Databases using SQLRPGLE

    I have requirement to connect more than one AS400 DB2 remote/distributed database to retrieve the Quantity by using SQLRPGLE Program. Found working with one remote DB, Retrieving the quantity & other Remote DB is getting connected, but while executing the SQL query it says SQL Package not...

    AS400DB2DBA5 pointsBadges:
  • Controlling C D I R options in the workstation message queue.

    Hello All, Could you please tell me how to control the C D I R options via programs. I mean that I do not want R to appear in screen and the functionality is automatically done. Can it be possible? If yes, please tell in detail and if not then what is the reason?

    Bigdumbo25 pointsBadges:
  • How to Add column (field) in ODBC to physical file?

    When I add a new field in ODBC, I can't find it in the physical file in the iSeries.

    afayek675 pointsBadges:
  • How to show table Constraints on AS/400

    Hello masters, I want to show table constraints on as400 database.I asked somebody people and they are said me; "Do not show (constraints - table relations) on AS/400". I don't believe that. And now asked How to show table constraints - relations on AS/400 I'm very curious about the answer to this...

    HBurakKaradag15 pointsBadges:
  • sql not retuning column using DB2 data reader

    Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level 'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2...

    ToddN200015,080 pointsBadges:
  • SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN200015,080 pointsBadges:
  • as400 db2 to sql server 2005

    how can we take a db2 backup tape and dump to a sql server 2005 database?

    Mingo5 pointsBadges:
  • DB2 HADR configuration

    Hi, wanted to check if anyone of you have experience in DB2 HADR configuration with 'reads on standby' enabled. We are looking for auto fail over between the nodes and balance the reads between the nodes. Does anyone has any prior experience with this configuration on the AIX environment? Thanks.

    kbsantosh15 pointsBadges:
  • Why do I need a logical file in DB2/400?

    Why do I need a logical file in DB2/400?

    db240050 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:
  • Add a field in existing file in DB2/400

    I need add a field in existing Physical file without impacting any other file? I know the CHGPF command but I'm not sure about which parameter needs to be update. Please advice.

    Askt265 pointsBadges:
  • Transfer data from DB2 file to SQL Server file

    I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou

    HABDOU5 pointsBadges:
  • Uploading records in a text file

    Hi.. I have PF with this format Ex: PF1 R REC FLD1 FLD2 For the above PF1 file I have records in a text file. For that I need to upload the records without using iSeries navigator and FTP also. Can anyone guide me? Regards, Ajmal khan.

    shyedajmal285 pointsBadges:
  • AS/400 – Logical file without key fields

    I am creating logical file without any key fields. Here both logical file and physical file do not have any key fields. How will be the access path built here?

    rajeshece1,215 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