Professional Web Applications Themes

db2clpex - IBM DB2

Have to telnet to Win2k machine with DB2 Universal 7 Personal running. From telnet I am trying to select from tables and etc. Having so much problems. IBM really messed up remote access to DB2 big time. They can't assume that on Win32 system people don't want to be like in Unix. Anyway here is the problem. CAn someone please give an example of successful use of db2clpex, please include your command lines and any data/batch files listing. ------------------------------------------------------------------------------C:\trash>db2clpex db2 -z log.txt "connect to Blahblah user db2user using password select * from user" ------------------------------------------------------------------------------ However log.txt shows the following errors: ...

  1. #1

    Default db2clpex

    Have to telnet to Win2k machine with DB2 Universal 7 Personal running.
    From telnet I am trying to select from tables and etc. Having so much
    problems.
    IBM really messed up remote access to DB2 big time. They can't assume
    that on Win32 system people don't want to be like in Unix.

    Anyway here is the problem. CAn someone please give an example of
    successful use of db2clpex, please include your command lines and any
    data/batch files listing.

    ------------------------------------------------------------------------------C:\trash>db2clpex
    db2 -z log.txt "connect to Blahblah user db2user using password
    select * from user"

    ------------------------------------------------------------------------------

    However log.txt shows the following errors:
    ------------------------------------------------------------------------------

    Database Connection Information

    Database server = DB2/NT 7.2.0
    SQL authorization ID = DB2USER
    Local database alias = Blahblah



    SQL0104N An unexpected token "*" was found following "<identifier>".
    Expected tokens may include: "NEW". SQLSTATE=42601
    ------------------------------------------------------------------------------
    Kenjis Kaan Guest

  2. #2

    Default Re: db2clpex

    Maybe you need the extra flags "-td" to specify that commands should be
    terminated by "" instead of ";"?

    db2 -td"" -z log.txt "..."

    Harold

    Kenjis Kaan wrote:
    > Have to telnet to Win2k machine with DB2 Universal 7 Personal running.
    > From telnet I am trying to select from tables and etc. Having so much
    > problems.
    > IBM really messed up remote access to DB2 big time. They can't assume
    > that on Win32 system people don't want to be like in Unix.
    >
    > Anyway here is the problem. CAn someone please give an example of
    > successful use of db2clpex, please include your command lines and any
    > data/batch files listing.
    >
    > ------------------------------------------------------------------------------C:\trash>db2clpex
    > db2 -z log.txt "connect to Blahblah user db2user using password
    > select * from user"
    >
    > ------------------------------------------------------------------------------
    >
    > However log.txt shows the following errors:
    > ------------------------------------------------------------------------------
    >
    > Database Connection Information
    >
    > Database server = DB2/NT 7.2.0
    > SQL authorization ID = DB2USER
    > Local database alias = Blahblah
    >
    >
    >
    > SQL0104N An unexpected token "*" was found following "<identifier>".
    > Expected tokens may include: "NEW". SQLSTATE=42601
    > ------------------------------------------------------------------------------
    Harold Lee Guest

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139