DSXchange

I need to find out the inputs and outputs (tables, hash file, sequential files) for all the jobs in a category. Though I know how to make a list of jobs in category by querying the DS_JOBS, I can't find a way to get the next step, i.e., getting the inputs and outputs details. I would appreciate any ...

Thank you all for the response.

When a column is dropped from a hash file and the hash file is being used in many jobs, I would like to know if the column definition has been modified in all the jobs. I will appreciate a lot if any one can help me or give me any idea how I can get this detail.

Thanks.

Thank you very much. Just curious to know if this message comes when Routines/Executables are also included in the export.

Thanks.

When exporting the project I got a meesage that "111 read only object were omitted". The export completed when I clicked the 'OK' button.

I will appreciate if any one can please help what this message is for and what it does. In my case, is the export really complete?

Thanks.

I get the warning message ds_uvput() - Write failed for record id '<Missing or NULL>'. In this job I have a hash file as the input, a hash file being used for lookup and then another hash file to write the data. I have about 4000 rows in the input. The lookup criteria is satisfied by about 250 recor...

Thank you Ray.

Thank you Kim and Ray. Ray when you mentioned "You can, however, load their defining expressions", what does this mean? Can you please expand on this?

Thanks again.

Kim, Thanks for the reply. I still can't figure out how to get the first date of the month. However I know how I can do that in a transformer using the following code: DATE.TAG(MONTH.FIRST((MONTH.TAG(@DATE))) - 1) So I just pasted the same line in the routine which looks as below but gives me compil...

I would like to determine the last date of the previous month in a routine that I later pass as paramter to a job. For example, today I should get 07-31-2005.

I will appreciate your help.

Thanks.

I looked in the forum for existing postings on this topic and was able to make it work. Hree is the code that works. Deffun UtilityHashLookup(A1,A2,A3) Calling "DSX.UTILITYHASHLOOKUP" RowNumber = UtilityHashLookup("HashAMERInvRowCount",1,1) Please note the catalog is "DSX&qu...

Sainath, thanks for the reply. With the use of Deffun statement I can compile. However, When I run the batch which has only the following lines of code, it aborts with no aparent error message. Deffun UtilityHashLookup(A1,A2,A3) Calling "DSU.UtilityHashLookup" RowNumber = UtilityHashLookup...

I am calling the routine UtilityHashLookup as below in the batch control: RowNumber=UtilityHashLookup("HashAMERInvRowCount",1,1) When I compile the batch I get the following error message. Please help me as to what I am doing wrong. How should I use the routine? Thanks. Compiling: Source =...

Thank you both for your suggestions. Now I know how to jandle this.

I have job to extract data from the source to a stage1 table. My need is not to delete the data in the target if there is no data in the source to extract from. The job has the following simple design: SeqFile ------> Transformer------------>Oracle Table I extract data incrementally from the source,...