1
  • Getting data from a SQL Server through Cobol – AS/400 application

    I've seen a lot of questions and answers about accessing data from SQL database but I am still not sure of how to handle what I need to do.  I have a Cobol application on our AS/400 that needs to get data from a SQL server. I have an ODBC connection already configured, but not sure how to...

    CWELLSEATON30 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...

    ToddN200059,990 pointsBadges:
  • Compile Program for previous system level

    Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using "CREATE PROCEDURE" command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this...

    Ketan19305 pointsBadges:
  • SQL/400 commands

    Hi friends, How can I see or get the SQL/400 commands executed from another user ? Regards, Roberto

    SILVARB440 pointsBadges:
  • SQL Precompiled Failed

    In SQLRPG program, when a compile a program it is showing the error SQL Precompiled Failed. I have given the sql syntax correctly. but I cant able to find the error. What may be reason for it? Please clarify.   Jayashree V.

    VJayashree185 pointsBadges:
  • SQL error SQL0204 while using scalar function calling RPGLE program

    I've created a sclar function in SQLRPGLE which will be calling a RPGLE program for processing. There are 2 functions in the SQLRPGLE program: one for handling character field and another for processing numeric fields. Character part is working fine, but if it processes numeric part (i.e. function...

    PG30 pointsBadges:
  • Multiple SQL For (AS/400)

    For (AS/400) I need to create a source member with multiple sentences of sql: i.e. update aa.... update bb.... update cc.... , and then run these source member with runsqlstm. Is it possible? which is the character to separate between sentences? Thanks in advance

    WSCST5 pointsBadges:
  • SQP file members

    Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?

    DMinNC10 pointsBadges:
  • Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?

    Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement? Have tried the following, which do not work: column descr254_mixed format A30 set wrap off select descr254_mixed from PS REQ_LINE SELECT left(descr254_mixed, 20) from PS_REQ_LINE

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL In CL/400

    Could it possibleto write SQL in CL/400 Programing?

    VENKYAS40075 pointsBadges:
1

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.

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

Following