hello everyone,
is there a command available so we can determine what job a particular
log file is associated with? i.e.
RT_LOG118 ..
any help appreciated..
Doris
datastage question
datastage question
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
datastage question
Doris
At TCL you can do it the Universe way or in SQL.
LIST DS_JOBS WITH JOBNO = "118"
Or SQL:
SELECT * FROM DS_JOBS WHERE JOBNO = 118;
Kim.
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Monday, December 01, 2003 12:04 PM
To: datastage-users@oliver.com
Subject: datastage question
hello everyone,
is there a command available so we can determine what job a particular
log file is associated with? i.e.
RT_LOG118 ..
any help appreciated..
Doris
At TCL you can do it the Universe way or in SQL.
LIST DS_JOBS WITH JOBNO = "118"
Or SQL:
SELECT * FROM DS_JOBS WHERE JOBNO = 118;
Kim.
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Monday, December 01, 2003 12:04 PM
To: datastage-users@oliver.com
Subject: datastage question
hello everyone,
is there a command available so we can determine what job a particular
log file is associated with? i.e.
RT_LOG118 ..
any help appreciated..
Doris
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
datastage question
Doris
JOBNO is defined as a string. So:
SELECT * FROM DS_JOBS WHERE JOBNO = '118';
Kim.
-----Original Message-----
From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com]
Sent: Monday, December 01, 2003 1:28 PM
To: datastage-users@oliver.com
Subject: RE: datastage question
Doris
At TCL you can do it the Universe way or in SQL.
LIST DS_JOBS WITH JOBNO = "118"
Or SQL:
SELECT * FROM DS_JOBS WHERE JOBNO = 118;
Kim.
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Monday, December 01, 2003 12:04 PM
To: datastage-users@oliver.com
Subject: datastage question
hello everyone,
is there a command available so we can determine what job a particular
log file is associated with? i.e.
RT_LOG118 ..
any help appreciated..
Doris
JOBNO is defined as a string. So:
SELECT * FROM DS_JOBS WHERE JOBNO = '118';
Kim.
-----Original Message-----
From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com]
Sent: Monday, December 01, 2003 1:28 PM
To: datastage-users@oliver.com
Subject: RE: datastage question
Doris
At TCL you can do it the Universe way or in SQL.
LIST DS_JOBS WITH JOBNO = "118"
Or SQL:
SELECT * FROM DS_JOBS WHERE JOBNO = 118;
Kim.
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Monday, December 01, 2003 12:04 PM
To: datastage-users@oliver.com
Subject: datastage question
hello everyone,
is there a command available so we can determine what job a particular
log file is associated with? i.e.
RT_LOG118 ..
any help appreciated..
Doris
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.