DSXchange

Can anyone give me some of the warnings that we suppress and that are not harmful.

thx

I can't think of any warnings in Server that need to be suppressed and are not harmful. PX jobs are different, but one can't just give a list since each warning is potentially harmful if not handled correctly.

Again, server jobs should be designed to not issue any warnings.

i agree to you andrw, i need a few most common ones atleast for documentation.

A purposeful reject link will generate a yellow warning message in the job log if the row count on the reject link is non-zero. Other than that, warning messages on Server jobs tell you your metadata is wrong, or your job has spewed information into the phantom capture file indicating non-numeric values in calculations or such errors.

You mean like "Character string truncation" warnings? (this is a harmful one) or "Warning: column name does not match SQL name!" (which might be harmful)?

You can enter TCL or use the ADMIN tool and do a "SELECT * FROM DS_RESENU;" (or "LIST DS_RESENU" for non-sql type query) to get a list of the messages that can come out of DataStage.

Can anyone tell me where i have enter the SELECT * FROM DS_RESENU etc, TCL etc

You can use your datastage adminstrator to run your command.

SELECT * FROM DS_RESENU

Under the project tab click the command button. Inside you can run your query.

rasi wrote:You can use your datastage adminstrator to run your command.

SELECT * FROM DS_RESENU

Under the project tab click the command button. Inside you can run your query.

I can execute the command "SELECT * from DS_RESENU;" from the administrator but not from unix. But i can execute commands like LISTV,LISTS etc.. from unix

I had even tried executing "select * from DS_JOBS;" both from administrator and from Unix. It is working fine from the administrator but not from unix.

The error message i get when i execute from unix is:
"Table DS_RESENU does not exist"
"TABLE DS_JOBS does not exist"

Am i making any basic mistake?

--Balaji S.R

You first need to change to your project from the master account by using a "LOGTO {projectname}" command within TCL.

ArndW wrote:You first need to change to your project from the master account by using a "LOGTO {projectname}" command within TCL. ...

Got it. Thanks a lot ArndW.

--Balaji S.R