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.
Dssearch command not recognizing category name having space
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Thu Jul 05, 2007 11:57 pm
- Location: India
- Contact:
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
-
- Participant
- Posts: 31
- Joined: Thu Jul 05, 2007 11:57 pm
- Location: India
- Contact:
yes, i have tried with single and double quotes as well, then also not working.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
Thanks
Sultan
Sultan
-
- Participant
- Posts: 31
- Joined: Thu Jul 05, 2007 11:57 pm
- Location: India
- Contact:
Thanks ArndW for the reply.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?
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
-
- Participant
- Posts: 31
- Joined: Thu Jul 05, 2007 11:57 pm
- Location: India
- Contact:
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
"You can never have too many knives" -- Logan Nine Fingers