Results 1 to 2 of 2

Thread: DB2 SQL Help

  1. #1
    Join Date
    Dec 2006
    Posts
    3

    Angry Unanswered: DB2 SQL Help

    Table Structure
    ID_I SMALLINT
    FLAG_F VARCHAR(1)

    I want to load this table with ID_I starting from 1 to 1000 and FLAG_F should be either 'Y' or 'N' selected at random.
    Can i have a SQL to load this table at one shot?

    Thanks
    DB2Rookie

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by Db2Rookie
    ID_I SMALLINT
    FLAG_F VARCHAR(1)
    I want to load this table with ID_I starting from 1 to 1000 and FLAG_F should be either 'Y' or 'N' selected at random.
    You could use recursive SQL (using a CTE) to generate the data for column ID_I; for column FLAG_F any pseudo-random number generator (scalar function) could be used (if pseudo-random is what you want).
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •