DSXchange

Hi, I am trying to get the start and end timestamp and row count for a job and store them in a table. I know there are various DS functions to do this. But I dont know the procedure of using them for my need. Do I have to use them in Job control window?. There is also a DSJobReport that can be used ...

Ravi,
How are you getting the file from mainframe? are you using DataStage FTP stage to pull the file ? even I coudnt make CFF work for me. I was pullling the file using FTP stage, the meta data for the file was not aligned properly with the incoming data and I had all sorts of nightmares.
Mack

Hi, I am using this code for generating the timestamp in DataStage.The Target Table being TeraData. I used this in SQL Server and it worked fine. Even in TeraData it works fine expect the precision is all zero. Oconv(DATE(),"D-YMD[4,2,2]"):" ":Oconv(TIME(),"MTS") : &quo...

Ray I use your greeting :D , hope its not copyrighted.
I just welcomed a guy, but guess he needs more information.

Welcome aboard :D You can start with reading the manuals first. The stages differ for server and parallel jobs. So go through the Server Job Developer's Guide and the Parallel Job Developer's Guide they can give you inforamtion on all the stages except for the Plug-in stages. You would also like to ...

In my case, the values for Code/Code _Name can be "AA"/"Code1" and also "AA"/"Code2" so basically they would be treated as a different row and the aggregations would be done on them as being distinct values. Actaully the grouping would be on Year, Code and Cod...

Thanks a lot. That was what I wanted but was contemplating various solutions. The SQL is definetely an option I would be looking into now.
Mack

For the Data below I would want the aggregation for all the months of 2004, and all the months of 2003, and till the max month of 2004 in 2003 Year,Month,"Code","Code_Name",Dollar 2004,09,"AA","Code1",25.50 2004,08,"AA","Code1",25.50 2003,1...

Hi, Iam trying to aggregate data on CYTD,PYTD,PYE. The CYTD and PYE are pretty straight as we group the aggregating columns on year and month. But how can I aggregate the PYTD which would be prior year to current month values. The meta data has year and month as separate columns. I am using a sort s...

I completely agree with ray. Most of the time the answers are hidden deep in the forum, it just takes a little digging. The person clicking the " I have searched the forum" will atleast would have a made a effort looking for the answer in the forum.

Its a one column. All the values of the column are fine expect this value. Some of the example values that were convereted right are The file was on mainframe and we use FTP stage to read it. The data format in EBCDIC is Pic(x), its char in the sequential file and SQL.

I hadnt backed it up. And about system level backup...woah..!!!!! Iam better of doing it again.
Thanks Roy

Well, I had a externally pathed hash file. I created a VOC and used the in account selected when reading the hash file. In the selection tab I used @ID BY @ID, I got sorted hash file on the key.

Just browsing through the forum, I tried what u said, works perfectly fine. Thanks!!!

Hi,
I wanted to know if we can retrieve a job we delete from the designer.
Thanks
Mack