1
  • Tables in DB2 z/OS

    In which dataset will I be able to find the default tables of DB2 V9 in Z OS

    KarishmaKapoor20 pointsBadges:
  • Dynamic sql with delete and commit

    Hi, I need to delete rows from different db2 tables in COBOL with commit in between after some 100 or 200 rows. Is there any away I can restrict my delete statement for some particular rows as in Select for fetch first 100 rows only. The values of table names will be known only during the execution...

    Sramki0 pointsBadges:
  • Add to Excel spreadsheet from System i

    I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

    ljjk1225 pointsBadges:
  • Changing the statement heap parameter on iSeries

    Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...

    Sbkhole0 pointsBadges:
  • Inserting data into a vargraphic data type field

    How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES('TEST') This gives a SQL error Please let me know how I can acheive it.

    Sbkhole0 pointsBadges:
  • Stored Procedure Error

    This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ------------------------------------------------------------------------ -- SQL Stored Procedure...

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

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