db2jdbcbind

[xixi]

Can you knowlege me how to do db2jdbcbind. i try it under command
window and doesn't work. i have to use alternate way java -cp
DB2Binder

db2 => db2jdbcbind -url jdbc:db2://xxxx:50000/xxxx -user xxx -password
xxxx
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "db2jdbcbin d -url
jdbc:db2://172.16.4.25" was found
following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<values>".
SQLSTATE=42601

[P. Saint-Jacques]

Re: db2jdbcbind

Xixi, I think you're trying to launch an executable from the interactive
command line processor.
Try putting a ! in front of the db2jdbcbind, as in: !db2jdcbcbind .....

If that does not work, issue a quit from the db2==> prompt. This will
put you in a command window. Resubmit your command as you have tpyed it
in your question.
HTH, Pierre.

xixi wrote:[color=blue]
> Can you knowlege me how to do db2jdbcbind. i try it under command
> window and doesn't work. i have to use alternate way java -cp
> DB2Binder
>
> db2 => db2jdbcbind -url jdbc:db2://xxxx:50000/xxxx -user xxx -password
> xxxx
> DB21034E The command was processed as an SQL statement because it was
> not a
> valid Command Line Processor command. During SQL processing it
> returned:
> SQL0104N An unexpected token "db2jdbcbin d -url
> jdbc:db2://172.16.4.25" was found
> following "BEGIN-OF-STATEMENT". Expected tokens may include:
> "<values>".
> SQLSTATE=42601[/color]

--
Pierre Saint-Jacques
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

[xixi]

Re: db2jdbcbind

i have tried on command window, still not work

C:\Program Files\IBM\SQLLI B\BIN>db2jdbcbi nd -url
jdbc:db2://xxx:50000/xxx -user admin -password xxx -size 70
'db2jdbcbind' is not recognized as an internal or external command,
operable program or batch file.

[PM \(pm3iinc-nospam\)]

Re: db2jdbcbind

Is db2jdbcbind.exe present under the bin dir?
The -size has a max value of 30 i think.
Look for it in the doc and maybe also for CLIPKG.

PM