There is no command, per se, at the UniVerse prompt for accomplishing this.
UniVerses "unload" is called UNLOAD.FILE.B, but it is not catalogued as a command. So there is a two step operation.
CATALOG APP.PROGS UNLOAD.FILE UNLOAD.FILE.B LOCAL
UNLOAD.FILE RT_LOGnn pathname
where RT_LOGnn is the job log for job number nn, and pathname is the output file (a ".u" suffix is conventional). For example:
UNLOAD.FILE RT_LOG42 /usr/tmp/rt_log42.u
This is almost certainly NOT the format you require. It is a format understood by UniVerses bulk load facility, loadfile.
The other issue, is that the record structure of RT_LOGnn does not lend itself easily to simple dumping. The message text is in the MSG.TEXT field (column), while the arguments for the message are in the MSG.ARGS field, which is multivalued.
You can generate a report from RT_LOGnn of course, for example using LIST RT_LOGnn or SELECT * FROM RT_LOGnn;
But the default output omits wave number and severity.
Therefore, before providing any more of an answer, what are you endeavouring to achieve? If its simply to dump the contents of a DataStage job log into a comma or tab delimited file, youre probably better off creating a routine or job control routine to accomplish this, so that you get exactly the information and format you require.
-----Original Message-----
From: William Tan [mailto:tanwill@adtel.esb.com.my]
Sent: Thursday, 25 October 2001 12:46
To: datastage-users@oliver.com
Subject: Extracting job log
Hi,
Im trying to extract tsome DataStage job logs into text files under the HP-UX. Does anyone know the command to do such a thing at the Universe prompt?
Thanks.
Regards,
William Tan
--------------------
Extracting job log
Ray, thanks for the detailed explanation.
What Im trying to achieved is to extract the logs into a text file. After asking the local Ascential engineer, his suggestion was to issue
the following command at the Unix prompt (at the project directory):
binuv "" >
The above command works. But I noticed that it took some 20 minutes for
the process to complete and this is just for 28 records.
Right now Im trying to choose and format the columns for better
results.
Regards,
William Tan
--------------------
----- Original Message -----
From: "Ray Wurlod"
Date: Thursday, October 25, 2001 11:50 am
Subject: RE: Extracting job log
> There is no command, per se, at the UniVerse prompt for
> accomplishing this.
>
> UniVerses "unload" is called UNLOAD.FILE.B, but it is not
> catalogued as a
> command. So there is a two step operation.
>
> CATALOG APP.PROGS UNLOAD.FILE UNLOAD.FILE.B LOCAL
>
> UNLOAD.FILE RT_LOGnn pathname
> where RT_LOGnn is the job log for job number nn, and pathname
> is the
> output file (a ".u" suffix is conventional). For example:
>
> UNLOAD.FILE RT_LOG42 /usr/tmp/rt_log42.u
>
> This is almost certainly NOT the format you require. It is a format
> understood by UniVerses bulk load facility, loadfile.
>
> The other issue, is that the record structure of RT_LOGnn does not
> lenditself easily to simple dumping. The message text is in the
> MSG.TEXT field
> (column), while the arguments for the message are in the MSG.ARGS
> field,which is multivalued.
>
> You can generate a report from RT_LOGnn of course, for example using
> LIST RT_LOGnn or
> SELECT * FROM RT_LOGnn;
>
> But the default output omits wave number and severity.
>
> Therefore, before providing any more of an answer, what are you
> endeavouringto achieve? If its simply to dump the contents of a
> DataStage job log into
> a comma or tab delimited file, youre probably better off creating
> a routine
> or job control routine to accomplish this, so that you get exactly the
> information and format you require.
>
> -----Original Message-----
> From: William Tan [mailto:tanwill@adtel.esb.com.my]
> Sent: Thursday, 25 October 2001 12:46
> To: datastage-users@oliver.com
> Subject: Extracting job log
>
>
> Hi,
>
> Im trying to extract tsome DataStage job logs into text files under
> the HP-UX. Does anyone know the command to do such a thing at the
> Universe prompt?
>
> Thanks.
>
> Regards,
> William Tan
> --------------------
>
>
>
>
What Im trying to achieved is to extract the logs into a text file. After asking the local Ascential engineer, his suggestion was to issue
the following command at the Unix prompt (at the project directory):
binuv "" >
The above command works. But I noticed that it took some 20 minutes for
the process to complete and this is just for 28 records.
Right now Im trying to choose and format the columns for better
results.
Regards,
William Tan
--------------------
----- Original Message -----
From: "Ray Wurlod"
Date: Thursday, October 25, 2001 11:50 am
Subject: RE: Extracting job log
> There is no command, per se, at the UniVerse prompt for
> accomplishing this.
>
> UniVerses "unload" is called UNLOAD.FILE.B, but it is not
> catalogued as a
> command. So there is a two step operation.
>
> CATALOG APP.PROGS UNLOAD.FILE UNLOAD.FILE.B LOCAL
>
> UNLOAD.FILE RT_LOGnn pathname
> where RT_LOGnn is the job log for job number nn, and pathname
> is the
> output file (a ".u" suffix is conventional). For example:
>
> UNLOAD.FILE RT_LOG42 /usr/tmp/rt_log42.u
>
> This is almost certainly NOT the format you require. It is a format
> understood by UniVerses bulk load facility, loadfile.
>
> The other issue, is that the record structure of RT_LOGnn does not
> lenditself easily to simple dumping. The message text is in the
> MSG.TEXT field
> (column), while the arguments for the message are in the MSG.ARGS
> field,which is multivalued.
>
> You can generate a report from RT_LOGnn of course, for example using
> LIST RT_LOGnn or
> SELECT * FROM RT_LOGnn;
>
> But the default output omits wave number and severity.
>
> Therefore, before providing any more of an answer, what are you
> endeavouringto achieve? If its simply to dump the contents of a
> DataStage job log into
> a comma or tab delimited file, youre probably better off creating
> a routine
> or job control routine to accomplish this, so that you get exactly the
> information and format you require.
>
> -----Original Message-----
> From: William Tan [mailto:tanwill@adtel.esb.com.my]
> Sent: Thursday, 25 October 2001 12:46
> To: datastage-users@oliver.com
> Subject: Extracting job log
>
>
> Hi,
>
> Im trying to extract tsome DataStage job logs into text files under
> the HP-UX. Does anyone know the command to do such a thing at the
> Universe prompt?
>
> Thanks.
>
> Regards,
> William Tan
> --------------------
>
>
>
>
Extracting job log
On 11 Aug 2000 I posted code to do this task on this list. It should be in the archives. If you cant find it there, I can email it to you off line. The technique is also taught on "Programming with DataStage BASIC". Enrol, or join a waiting list, today!
-----Original Message-----
From: William Tan [mailto:tanwill@adtel.esb.com.my]
Sent: Thursday, 25 October 2001 15:04
To: datastage-users@oliver.com
Subject: Re: RE: Extracting job log
Ray, thanks for the detailed explanation.
What Im trying to achieved is to extract the logs into a text file. After asking the local Ascential engineer, his suggestion was to issue the following command at the Unix prompt (at the project directory):
binuv "" >
The above command works. But I noticed that it took some 20 minutes for the process to complete and this is just for 28 records.
Right now Im trying to choose and format the columns for better results.
Regards,
William Tan
--------------------
----- Original Message -----
From: "Ray Wurlod"
Date: Thursday, October 25, 2001 11:50 am
Subject: RE: Extracting job log
> There is no command, per se, at the UniVerse prompt for accomplishing
> this.
>
> UniVerses "unload" is called UNLOAD.FILE.B, but it is not catalogued
> as a command. So there is a two step operation.
>
> CATALOG APP.PROGS UNLOAD.FILE UNLOAD.FILE.B LOCAL
>
> UNLOAD.FILE RT_LOGnn pathname
> where RT_LOGnn is the job log for job number nn, and pathname is the
> output file (a ".u" suffix is conventional). For example:
>
> UNLOAD.FILE RT_LOG42 /usr/tmp/rt_log42.u
>
> This is almost certainly NOT the format you require. It is a format
> understood by UniVerses bulk load facility, loadfile.
>
> The other issue, is that the record structure of RT_LOGnn does not
> lenditself easily to simple dumping. The message text is in the
> MSG.TEXT field (column), while the arguments for the message are in
> the MSG.ARGS field,which is multivalued.
>
> You can generate a report from RT_LOGnn of course, for example using
> LIST RT_LOGnn or
> SELECT * FROM RT_LOGnn;
>
> But the default output omits wave number and severity.
>
> Therefore, before providing any more of an answer, what are you
> endeavouringto achieve? If its simply to dump the contents of a
> DataStage job log into a comma or tab delimited file, youre probably
> better off creating a routine
> or job control routine to accomplish this, so that you get exactly the
> information and format you require.
>
> -----Original Message-----
> From: William Tan [mailto:tanwill@adtel.esb.com.my]
> Sent: Thursday, 25 October 2001 12:46
> To: datastage-users@oliver.com
> Subject: Extracting job log
>
>
> Hi,
>
> Im trying to extract tsome DataStage job logs into text files under
> the HP-UX. Does anyone know the command to do such a thing at the
> Universe prompt?
>
> Thanks.
>
> Regards,
> William Tan
> --------------------
>
>
>
>
-----Original Message-----
From: William Tan [mailto:tanwill@adtel.esb.com.my]
Sent: Thursday, 25 October 2001 15:04
To: datastage-users@oliver.com
Subject: Re: RE: Extracting job log
Ray, thanks for the detailed explanation.
What Im trying to achieved is to extract the logs into a text file. After asking the local Ascential engineer, his suggestion was to issue the following command at the Unix prompt (at the project directory):
binuv "" >
The above command works. But I noticed that it took some 20 minutes for the process to complete and this is just for 28 records.
Right now Im trying to choose and format the columns for better results.
Regards,
William Tan
--------------------
----- Original Message -----
From: "Ray Wurlod"
Date: Thursday, October 25, 2001 11:50 am
Subject: RE: Extracting job log
> There is no command, per se, at the UniVerse prompt for accomplishing
> this.
>
> UniVerses "unload" is called UNLOAD.FILE.B, but it is not catalogued
> as a command. So there is a two step operation.
>
> CATALOG APP.PROGS UNLOAD.FILE UNLOAD.FILE.B LOCAL
>
> UNLOAD.FILE RT_LOGnn pathname
> where RT_LOGnn is the job log for job number nn, and pathname is the
> output file (a ".u" suffix is conventional). For example:
>
> UNLOAD.FILE RT_LOG42 /usr/tmp/rt_log42.u
>
> This is almost certainly NOT the format you require. It is a format
> understood by UniVerses bulk load facility, loadfile.
>
> The other issue, is that the record structure of RT_LOGnn does not
> lenditself easily to simple dumping. The message text is in the
> MSG.TEXT field (column), while the arguments for the message are in
> the MSG.ARGS field,which is multivalued.
>
> You can generate a report from RT_LOGnn of course, for example using
> LIST RT_LOGnn or
> SELECT * FROM RT_LOGnn;
>
> But the default output omits wave number and severity.
>
> Therefore, before providing any more of an answer, what are you
> endeavouringto achieve? If its simply to dump the contents of a
> DataStage job log into a comma or tab delimited file, youre probably
> better off creating a routine
> or job control routine to accomplish this, so that you get exactly the
> information and format you require.
>
> -----Original Message-----
> From: William Tan [mailto:tanwill@adtel.esb.com.my]
> Sent: Thursday, 25 October 2001 12:46
> To: datastage-users@oliver.com
> Subject: Extracting job log
>
>
> Hi,
>
> Im trying to extract tsome DataStage job logs into text files under
> the HP-UX. Does anyone know the command to do such a thing at the
> Universe prompt?
>
> Thanks.
>
> Regards,
> William Tan
> --------------------
>
>
>
>