• AS400 ODBC

    Hi Our company uses AS400 for our financial processing application. The users access the AS400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...

    Pgsdeb20 pointsBadges:
  • AS/400,db2/400,rpg/400

    is there any perfect method to make externally described file fields available to a program

    0 pointsBadges:
  • Internal vs Externa Stored Procedure Performance

    Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...

    Baron4005 pointsBadges:
  • Assign default values to SQL VIEW columns

    I'm trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I've tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.

    Tgee60 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • db2 to excel

    i was tryin to import from db2/400 into excel but when i did. the description came up in a different language...in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

    Doodoo5 pointsBadges:
  • DB2/400 Error Trapping

    how to trap error in dds ie.., db2400 

    Gchakradhar15 pointsBadges:
  • can anybody tell me how to know max sal in db2/400 means in pf

    can anybody tell me how to know max sal in db2/400 means in pf

    Siru15 pointsBadges:
  • AS/400 : DB2/400 file override

    I have following scenario:- - in CL, override on PF to share ODP - Calling PGMx where above PF will be open using OPEN operation. - In PGMx,once file is open,calling another pgm(PGMy) to read the same file ( PF ) for specific record using READ operation (without SETLL ). Question : Record...

    Samule400160 pointsBadges:
  • content of source physical

    hi all, can any one plese tell ,how can we see the content of any source physical

    Ambrish 82310 pointsBadges:
  • how to access any particular menber of any pf

    Hi, if i have a pf having 5 members..how can i access 3rd member of it through in rpgile.. regards Ambrish

    Ambrish 82310 pointsBadges:
  • db2/400

    Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?

    I6195 pointsBadges:
  • Changing DB2 Short or Internal Names

    We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001...

    RodVerity20 pointsBadges:
  • Having trouble with DB2/400 UDF returning a table.

    I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I...

    Dwk0015 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:
  • Diff. between PF and a sql table

    can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

    Anky10 pointsBadges:
  • system storage

    Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP('/') NOW I AM...

    Anky10 pointsBadges:
  • SQL error

    I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

    Nutangujar895 pointsBadges:
  • CPYTOIMPF data corruption

    CPYTOIMPF on V5R4 with latest PTF's adds invalid data to the created CSV file for some blank fields in the PF. Is this a Bug?

    JMShmc5 pointsBadges:
  • DB2 connection in VBscript

    I need to delete some records from a DB2 database on an AS400 using VBscript.

    Larksys5 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