DSXchange

1. You will retain existing server job functionality exactly as it is. Enterprise Edition gives you additional (parallel job) functionality. The two co-exist and do not, generally speaking, overlap ... Currently I am not a premium member, so can please send me you full detail. It is very valueable ...

Hi, Currently we are running our DataStage and Quality Stage jobs on 7.5 Server version. We are thinking to use Enterprise Edition capabilty on 7.5 version. I have following question in this regard 1: What will happen at the time of instalation of EE, does EE will get install as seperate identity or...

I have an EBCDIC file which I have to convert it to ASCII format. Can anyone let me know which stage or what I should do in DataStage to accomplish this.
Thanks & Regards

Hi, Check with the datatypes and the data you are assigning. if you want to catch the rejected records you can use Link varibales/ouput/rejected or DBMS.CODE or SQLCODE. Meena, Thanks, but I don't understand what you mean here -> use Link varibales/ouput/rejected or DBMS.CODE or SQLCODE. You can us...

Krazykoolrohit wrote:Do a search on the forum.

we had this discussion today also.

viewtopic.php?t=102182&highlight=save+log

Rohit it doesn't work how I wanted to save. I would like to save as it is in the log, not only time and job names.
Do you have any idea

I know there is a filter property in the sequential stage but i dont know how to use that can someone give me the example. You can use sort stage which is supplied by DS (remember this will be very slow if you are dealing with big file) or you can use CoSort (this is tool by which you can do sort, ...

In our daily run of DataStage jobs, we just keep for 2 weeks of log (Run history of job status). I have to save the run log information for some perticular date to do a comparison. I have looked into DS Director found one place to copy log into some folder but its not working how it has been defined...

Can anyone please tell that is there any kind of Time generator in DataStage to create time dimesion table. For example is there any place in DataStage where I can defined start and end dates and the frequency by which system can generate time dimension for me. Help will be highly appreciated. Thank...

If you just want to see data of RT_LOG table of a particular job, you can use DataStage Administrator. From Administrator choose the project and click on the execute command. In the resulting window give the following command. SELECT @ID,TYPE,WAVE.NO,TIMESTAMP,MSG.ARGS,MSG.TEXT,FULL.TEXT,SEVERITY F...

Hi, What information are you looking for? I do not think that there is a table my name DS_LOG. Ketfos As you know when you run DataStage, DataStage log all the informtions into log file and after running you go and look into log file to see status. What happens in the back ground that DataStage kee...

Hi Guys, Can any one get me the detail of DS_LOG table. Like how many columns are in this table, what are there names, how I can fetch these columns while running a DataStage job. I can get this info from telnet, but I don't have IP address (to get this I need atleast one week and I don't have this ...

Hi Perwez, Here are some inputs. You need to design your jobs in such away that they handle all the cases where you reject the record to somewhere along with the reason why it rejected. That takes you to have all the rules framed in the process and validating your input data on those rules and reje...

Hi Guys As per my requirement I have to dump all error messages, error codes and time for error to a company built centralised error database (which they use to track all errors in their whole system and send emails to respective employees). I have found there are DSGetJobInfo, DSAttachJob fuction, ...

I vaguely remember an Excel ODBC in Unix OS. Search this forum and other search website for this info. Dear Sri, I am not talking about Excel ODBC in Unix (I also never heard of this), I was talking about Microsoft Excel. A very simple DataStage job which get the data from an Oracle source and dump...

Hi Everyone, I have to develope a job. The function of this DataStage job will be to get input data from a Oracle database and without any changes (No work in tx) I have to write in a traget file which will be EXCEL SHEET. I know I can write in CSV file and can open in Excel. I need help of you guys...