DSXchange

Hi, I work in a support environment, I need to use Datastage Director Hourly basis, My problem is that there is only one project and there are serveral subject areas and subfolders in the production system. I need to visit each and every folder every hour to see if there are any job failures/Aborts ...

I have a requirement where I need to reject records which do not have 'MM/DD/YYYY' format date and it is a RCP enabled job and I am not supposed to use a Transformer . I am also loading the processed records onto Oracle table and reject records into an reject file. Let me know if some one found the ...

My target file is comma separated file .Now i cant distinguish between , in a record and , which is there for as a record separator. hence this requirement.

I didnt knew that my english was so poor. Sorry

In my parallel job I am writing data to a Sequential stage file. Its a comma delimited file.With all Varchar coloumns in source. As per Seq stage all varchar coloumn data is quote when writtent to file though we have option to remove the quotes. But it should double quote data with comma in it. In d...

I have a source data file in XML format , I need to extract data from the XML file and place it in a table. I am able to process the file successfully. But I am not able to handle errors. Say If I change any format of any one row out of 100 rows and process the file. The job still executes successfu...

@chulett : Yes the number of jobs could be changed. Hence i was looking for a passing job name kind of approach method.

I would appriciate if you could suggest any good method to do this?

I have 25 parallel jobs that need to be executed in a order. Need a suggestion where i need not add 25 stages to the Sequncer job instead pass the parallel job name to one stage and get them executed.




Ranjan

I am using a ODBC connector stage and trying to insert and select on it. I am tryin this way. In Before SQL section I am trying to insert data into table XYZ and in the select section i am writing a select col1,col2 from XYZ. While the connector and results are working fine. I am not seeing any inse...

Hi Sree, I have set of jobs that are being executed simultaneously. I trigger all of them from autosys. Even I feel that there is an issue with space. The job mostly fails when other jobs also running. Other wise its absolutely fine. Can you suggest another approach for the sql query which does not ...

I have a sql query in the below format WITH temp1(col1,col2,col3) as ( SELECT C1,C2,C3 FROM TABLE1 ) SELECT COUNT(COL1) AS STD,'CLS' AS CLASS1 UNION ALL SELECT COUNT(COL2) AS HLM,'ABC' AS CLASS1 This query runs successfully on sqlserver and also this is wokring fine on datastage 8.1 sql connector. M...

No. Ray i dont see any issues with the example now. If you are aware of datedadd() function of sqlserver may be you will be able to get a clear picture. However i tried solving this by getting the month number first and subtracting 30/31 days based on the month number(got from MonthFromdate()).How e...

DATEADD(month, -1, getdate()) This is the function in SQL server which gives timestamp corresponding to last month. Now I want to implement the same logic in one of the columns for transformer. I have tried serveral predefined options of datetime and current timestamp functions in transformer which...

Can some one help me on this. I am using a ODBC connector and want to send dates as parameters to the sql query in connector. This date should be the execution date in autosys. i.e i have to capture execution datetime from autosys and handle the same in the job and fetch records.Can some one help me...

All, I am new to datstage and working on 8.1 version of it. I have a requirement where my aggregator stage outputs the data in the form of

Col1 Col2
ABC 21
xyz 52
pqr 94
opq 36
please suggest me in converting above rows in to columns like below

ABC xyz pqr opq
21 52 94 36