orchdbutil - Documentation / escape character?

[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.

[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

[mtadich]

For the first question, try \ immediately before the "special" character.

[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.