Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Unanswered: Turning off DB2 result set headers and feedback

    From the result of a db2 query ,
    How can we turn off following output
    1. column names
    2. "---------"
    3.xx record(s) selected.

    For eg:-
    We have the following problem with DB2:-


    When we fire a query,
    db2 => select * from test

    the output is :-
    NAME ADDRESS NO
    ---------- ---------- -----------
    hello aa 2
    hello aa 3
    hi b1 3

    11 record(s) selected.

    We do not want :- NAME ADDRESS NO,
    ---------- ---------- ----------- , and 11 record(s) selected.

    Thanks in advance

    Subhash

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Turning off DB2 result set headers and feedback

    db2 -txvf <filename>

    or , for interactive mode, start the db2 command window with

    db2 -x

    Cheers

    Sathyaram


    Originally posted by subhash13
    From the result of a db2 query ,
    How can we turn off following output
    1. column names
    2. "---------"
    3.xx record(s) selected.

    For eg:-
    We have the following problem with DB2:-


    When we fire a query,
    db2 => select * from test

    the output is :-
    NAME ADDRESS NO
    ---------- ---------- -----------
    hello aa 2
    hello aa 3
    hi b1 3

    11 record(s) selected.

    We do not want :- NAME ADDRESS NO,
    ---------- ---------- ----------- , and 11 record(s) selected.

    Thanks in advance

    Subhash
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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