DSXchange

Hi Ray

I want to capture them from dsodb of operations console db introduced from 8.7 onwards.

can you please tell me how can i query the tables from dsodb to load that a scheduled day every job run.

Dear Team, I need to build a job such that it has to get the job run in formation like job name,job status,start time,end time,row count,created by,updated by fields etc fields. how can store these fields values in a file/table if we use job control routine? is there any functions in parallel trnsfo...

Hi ArndW,

I have created the message handler in the job and after that i ran the job but i am not importing /exporting the job.

I checked the message handler in the server and it exists.

Please tell me what would be the wrong here ...

Thanks

Hi All, I am getting warning in one of the job and i created the message handler to supress warning /demote to informational by add rule to message handler with right click on director log warning. after creation and try to run the same job still i am able to see the warning. Looking forward for the...

hi venky

please provide server routine

Arndw,

Dont think that my questions are vague....Just i am trying for possible ways i can achive this.

Expecting an answer from you for solution.

looking farward for the sugessions from some one

I dont see any such counts information in job log can you please tell me where to find the same in log

Dear All,

I need to get all the success counts, error counts and warning counts of records loaded in a datastage job.

anyone please guide me on this.

regards

How to build a routine using these

Hi Arndw,

How can we change from 32 bit to 64 bit in hash files when os is of 32 bit?

Hi All,

The windows os is 32 bit type.

Hash Files are of 32 bit dynamic hash files.

If the size of the file is more than 2 gb ,is it possible to change to 64 bit in datastage even on 32 bit windows OS?

Hi All, I am Loading multiple source files in .csv format into oracle tables. I need to update the job control table with jobname,batchno,file name and file date information once after job is completed . Please suggest me how to get file name ,file date ,batchno using server routine. Which of the DS...

Hi All,

I need to capture message types information (Info,warnings and fatals) and each message detail in the datastage job log and store in oracle table.

please suggest me any server routine on windows for this .

Hi All, I need to ftp the files of type say 1.settlement 2.statements from source server to ds server. There will be multiple files for each type of files. Once the all the files are ftped to DS Server,I need to run each file to load into staging tables. How to implement using ftp script for this. a...