Dssearch command not recognizing category name having space

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sultan@cts
Participant
Posts: 31
Joined: Thu Jul 05, 2007 11:57 pm
Location: India
Contact:

Dssearch command not recognizing category name having space

Post by sultan@cts »

Hi All,

dssearch command was not recognizing category name if we have the space in between.

Example:

./dssearch -ljobs -matches -sub -c DE ACCT -j s dpr_rs_dev>>/data/dw/rs/dev/seqfiles/tempJobsList1.txt

DE ACCT is the category name.

If the category name is single word like ACCT then its working.

Please help me in this issue.
Thanks
Sultan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Have you tried quoting?

Code: Select all

./dssearch -ljobs -matches -sub -c 'DE ACCT' -j s dpr_rs_dev>>/data/dw/rs/dev/seqfiles/tempJobsList1.txt 
sultan@cts
Participant
Posts: 31
Joined: Thu Jul 05, 2007 11:57 pm
Location: India
Contact:

Post by sultan@cts »

ArndW wrote:Have you tried quoting?

Code: Select all

./dssearch -ljobs -matches -sub -c 'DE ACCT' -j s dpr_rs_dev>>/data/dw/rs/dev/seqfiles/tempJobsList1.txt 
...
yes, i have tried with single and double quotes as well, then also not working.
Thanks
Sultan
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I didn't even know that categories can be created with embedded spaces. When you execute the command with quotes, what is the dssearch output?
sultan@cts
Participant
Posts: 31
Joined: Thu Jul 05, 2007 11:57 pm
Location: India
Contact:

Post by sultan@cts »

ArndW wrote:I didn't even know that categories can be created with embedded spaces. When you execute the command with quotes, what is the dssearch output?
Thanks ArndW for the reply.

we can create the categories with spaces in between .

We tested with giving quotes its working fine now.previously we ran in different project.
dssearch -ljobs -matches -sub -c 'DE ACCT' dpr_rs_dev>>/data/dw/rs/dev/seqfiles/tempJobsList4.txt

Can you let us know , how to get the subcategory list cfrom the command line.
suppose if we have jobs-->DE ACCT-->Subcategory.Now we need the list of jobs from Subcategory folder.
Thanks
Sultan
sultan@cts
Participant
Posts: 31
Joined: Thu Jul 05, 2007 11:57 pm
Location: India
Contact:

Post by sultan@cts »

Please help me, to get the jobs list from subcategory through command line.
Suppose if we have jobs-->DE ACCT-->Subcategory.Now we need the list of jobs from Subcategory folder.
Thanks
Sultan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

From a TCL prompt or using dssh:

Code: Select all

SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'xxxxxx';
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply