Need to search a Sequential file for example x.csv in jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Tue Jun 20, 2006 3:53 am
Need to search a Sequential file for example x.csv in jobs
Need to search a Sequential file for example x.csv where all it is used in the jobs and can I get using Datastage.Is it possible using this Datastage.
Kalyan
Kalyan
Kalyanachakravarthy VS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%x.csv%');
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray
I was trying to run this query
SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%x.csv%');
But it is failing
DataStage/SQL: syntax error. Unexpected symbol. Token was "@RECORD".
Any suggestions?Thanks in advance.
I was trying to run this query
SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%x.csv%');
But it is failing
DataStage/SQL: syntax error. Unexpected symbol. Token was "@RECORD".
Any suggestions?Thanks in advance.
Regards
Lotus26
Lotus26
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes..It worked for me .But a small syntax change like I have used:
/dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL '@RECORD' LIKE '%x.dat%');"
Thanks for all your suggestions.
/dsadm/Ascential/DataStage/DSEngine/bin/uvsh "SELECT NAME FMT '32L', CATEGORY FMT '40L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL '@RECORD' LIKE '%x.dat%');"
Thanks for all your suggestions.
Regards
Lotus26
Lotus26