Page 1 of 1
orchdbutil - Documentation / escape character?
Posted: Mon Apr 03, 2006 10:20 pm
by asorrell
1st question - at this particular customer site the passwords contain lots of special characters. When used with orchdbutil, they cause problems. Does anyone know if there is an "escape" character that I can use to tell it to ignore special character(s)?
2nd question - I know the orchdbutil command prints out its options from the command line. Is there any further documentation available? I've scanned the online documentation and the Orchestrate manuals and not spotted anything of substance.
Re: orchdbutil - Documentation / escape character?
Posted: Tue Apr 04, 2006 11:53 pm
by anujgarg
Hi,
I am new to datastage.I have seen that they are various utilities available under orchestrate.
Can you tell me where i can find online documentation related to PX which you are talking and the Orchestrate manuals .
thanks in advance,
Anuj
Re: orchdbutil - Documentation / escape character?
Posted: Fri Apr 28, 2006 9:31 am
by mtadich
For the first question, try \ immediately before the "special" character.
Posted: Fri Feb 16, 2007 11:01 pm
by ray.wurlod
On a Windows machine I used the /? switch to get the following. On a UNIX machine try orchdbutil with -H or with no command line options at all. It's a start.
Code: Select all
D:\Ascential\DataStage\PXEngine\bin>orchdbutil /?
##I TFCN 000001 15:37:02(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##E TCDU 000000 15:37:02(001) <main_program>
Usage:
orchdbutil
[exists | show | drop | clear | create | check | exec | tablenames] <options>
All subcommands require the -dbtype option. Values for dbtype
include: db2, informix, informix_xps, oracle. Options accepted
by all subcommands include: -server, -dbname, -dboptions, -db_cs.
exists <tablename>
Sets the command's status to 0 if the table exists, 1 otherwise.
show <tablename>
Display the ORCHESTRATE schema for the specified table.
drop <tablename>
Drop the specified table from the database.
clear <tablename>
Delete all rows from the specified table.
create <tablename>
Create a new table in the database. The -schema or -schemafile
option is required. Additional options accepted:
-truncate
Truncate the length of field names that exceed the maximum
allowed by the database.
-stringlength <n>
Specify a max string length for unbounded length strings/raws.
-createoptions 'options'
Specify database specific creation options
check
Check a query and display schema of the resulting dataset.
This can take one of two forms:
-table <tablename> [-selectlist <selectlist>] [-filter <filter>]
- OR -
-query <query>
These are analogous to the standard database read operator forms.
nodemap
Check a query and display the nodemap that will be used to
place the database read operator, if appropriate. This takes
one of two forms:
-table <tablename>
- OR -
-query <query> [-partitiontable <table>]
These are analogous to the standard database read operator forms.
exec 'sql'
The specified SQL statement is passed to the database for
execution. Use with care.
tablenames
-owner <owner>
Prints out the tables owned by the specified user
You must have APT_ORCHHOME and APT_CONFIG_FILE set.