Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. esskayind

    Fetch value from Dynamic SQL

    Hi, You can declare a cursor for the select statement,open it , fetch into a variable and close the cursor. I think, It helps you. Thanks, Thangam
  2. esskayind

    Suppress column headings & rows counts in CLP

    Hi, You can suppress the column heading and rowcount by executing the query using the following command from CLP DB2 -x "SELECT * FROM ANYTABLE" By, Thangam
  3. esskayind

    Date Formatting

    Hi, In DB2,Format function is not available.By default the date format is mm/dd/yyyy If you want to have different format,you can use the following LTIRM(RTRIM(CHAR(DAY(l_date))))||LTIRM(RTRIM(CHAR(MONTH(l_date))))||LTRIM(RTRIM(CHAR(YEAR(l_date))) The above one is just a example.If you...
  4. esskayind

    DB2 Application Heap

    Hi, Did you try to increase applsz parameter values?. It defines the number of private memory pages alloted for application by the database manager on behalf of the specific agent(Agent coordinates for processing the application request and makes the comunication between the application and...
  5. esskayind

    DB2 Application Heap

    Did you try to increase applsz parameter values. It defines the number of private memory pages alloted for application by the database manager on behalf of the specific agent(Agent coordinates for processing the application request and makes the comunication between the application and...
  6. esskayind

    DB2 OLAP Server vs Cognos Transformer in cube building

    I want to know the Built-in tools avaliable in DB2 for ETL,OLAP and Query & Reporting and also the third party tools for the above ones.
  7. esskayind

    etl testing tools

    I want to know the Built-in tools avaliable in DB2 for ETL,OLAP and Query & Reporting and also the third party tools for the above ones.
  8. esskayind

    DECODE in DB2

    Hai, We have CASE expression in DB2 as workaround for DECODE Function in Oracle. Eg. Select DECODE(Name, 'XXX','My Name','Your Name') from TableName; Select CASE NAME WHEN 'XXX' THEN 'My Name' ELSE 'Your Name' END from TableName I hope,The above eg. will help you

Part and Inventory Search

Back
Top