DSXchange

Thank you very much for all.
Nivas

ArndW wrote:"dsjob -log" inserts a record into the log, you are looking for "dsjob -logsum" ...

Excellent.

Thanks
Nivas

Same answer for Windows. I am trying to find how do I read from output stream to a file in DOS. The following I am getting. C:\ASCENT~1\DATAST~1\Engine\bin>dsjob -log HSNOUB92Warehouse BatchHSNOCHCWarehou se1 Enter message text, terminating with Ctrl-d Nivas^D Message read. After this How do read t...

The job log is in a DataStage table and is not a sequential file. You can use the UNIX command "dsjob -log <project> <job>" to get this information listed to standard output and could redi ... How can we get the log info with Windows as OS. I am trying to view the log other than Director....

Use OpenSeq, Create and WriteSeq

Hi I was able to insert data from flat file to excel workbook with the help from our earlier posts. Now I got another one. When I insert a numeric/integer value into the spread sheet, the datastage is actually putting a apostrophe at the begining. For example the the actual value is -2014807879 but ...

Thanks for the response. Now I am getting the following error. Please help me out EXCELTest..map.DSLink13: DSD.BCIPut call to SQLExecute failed. SQL statement:UPDATE `Sheet1$` SET COL2 = ?, COL3 = ?, COL4 = ? WHERE (COL1 = ?) SQLSTATE=S1000, DBMS.CODE=-3035 [DataStage][SQL Client][ODBC][Microsoft][O...

I am able to create multiple EXCEL spread sheets based on first filed in the sequential file. Now instead of creating multiple spread sheets I want to create multiple tabs in one spread sheet.

thanks
nivas

I have a sequential file which has coma seperated values. I need to create EXCEL work book with this data. Based on the First Filed in the sequential the data should be moved to different tabls in the EXCEL work book. I should be able to name the tab with first field value in the sequential file. Co...

This topic earlier explained. But I would like to give brief info.

You need to use variables and concatenate the cols based on key col . You need to use hash file and make the key col as the key in hash file. There by you will have the vertical pivot records in hash file.

Using Sequential File stage if you create a file with extention .csv and select the check box First Line is column names, delimiter as "," there by it will create a spread sheet with first row as column names and the rest rows with data.

You can use sequential stage and create the file as .csv. This will create a EXCEL spread sheet.

using IsNull datastage function handle the nulls set a default value

Three steps involved.
1. In the SQL order the records on first column.
2. Inside the transform use stage variables and concatenate second columns for the same first column value.
3. out put the records from transformer to Hash File making the first column as the key column in hash file.

use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options.