DSXchange

Hello,

How do I create an online Documentation with schema and generated code for my jobs ?

Thanks

Hi ! Currently My Job Log Name is of the form : JobName_Date_ Time I use the DSJobReport in the After Subroutine to get the log. How Can I customize the name of the Job Log ? In addition to having a job log I would like to be notified whenever there is an error or if a job fails. How can I do this ?

ray.wurlod wrote:No.

However, if you call DataStage jobs using dsjob from a script, you can re-map the standard exit codes within that script. ...

How Can this be accomplished ?

Hi I need to unlock a DB2 Table. How do I do this ? I was trying to load to a target table and then i aborted the job as it was taking a long time. The target table is empty and I wanted to verify it. When I clicked view data it hung up. I am assuming this is due to a table lock..Please help as to h...

Target Length is 26.

I am using TimeDate() in one of the transformer columns....Do u think I should convert it to internal and then reconvert it ???

chulett wrote:The DB2 stage wants dates in internal format, from what I recall. ...

I am trying to insert the Current Time Stamp in to a target Column.

when I have the target as a Sequential File My OutPut for that column is of the form :15:07:29 18 MAY 2007


But When My Target is a DB2 Table My Out Put is :

0015-11-27 17:26:43.694000

Any suggestions to correct this ?

Hi I tried doing a clean up, but it doesnt take effect....Would you mind telling me the steps and also how i can do it unix.

Thanks

cosec wrote:Hi,

I cannot access my job as it says it's being accessed by another user. Any remedies for this ?


Thanks

Hi,

I cannot access my job as it says it's being accessed by another user. Any remedies for this ?


Thanks

hi, I am trying to have all my error codes and error messages organized in a file... Are there any particular functions to get the error code and error message ? I tried the available DS MAcros but didn't get what I was expecting... Would appreciate if some one could point me in the right direction

Hi,

Thanks for the Help...I was able to get my desired tests done...Thanks

What is the format to enter the name of the server if I use the plug in meta data server option ? The import dialogs ask for server name and other authentication information. Just do them one at a time, correctly pointing to the correct server. You may have additional issues if the servers are ...

I need to create a DSN in unix so that I could import table definitions from a remote source. If anyone knows please suggest how I could do it .

Thanks

Thanks

rafik2k wrote:Better involve DBA to create dsn for you.
You need to create dsn in server where DatStage resides.

For windows environment you can create system dsn using Data Sources(ODBC) under control panel.

Search web for more information.

hi Rafik thanks.

Its a db2 database. how do i create the dsn ?

rafik2k wrote:Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?

Trying to connect to a DB2 Source. The Target is also DB2

rafik2k wrote:Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?