DSXchange

ray.wurlod wrote:"Displayed" using what utility? ...

Displayed using Utility tool 'Squirrel'.......Is the problem I am having due to the default setting of the Utility tool ?

I am doing some tests to load a date YYYYMMDD from a sequential file that needs to be stored as YYYYMMDD in a DB2 table. In the DB2 Table the data type for the DUE_DT is DATE I use the following conversion rule Iconv(Input.DUE_DT,"DYMD") but the result is displayed as YYYY-MM-DD 00:00:00.0...

Hi all, There are two cases where the Datastage Job takes an extremely long time to complete. Case (i) Extract from a Sequential File and Load to a DB2 Table. Case (ii) Exract from Multiple DB2 Tables and Load to a DB2 Table The issue in Case (i) is that the loading time is very long.... jobs that u...

Hello, I am trying to insert 1 record to an empty table.... and when I run the job I get the following error: DBMS.CODE=-407, SQLSTATE=23502, [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=7, TABLEID=275, COLNO=7" is not allowed. SQLSTATE=2...

That I am not too sure but from your answer I guess it's not possible to do what I want...Thanks !

ray.wurlod wrote:Why do you say "at the moment"? Do you have some inkling that Microsoft is going to change the way it works?

Hi,

Is it possible to insert data in to multiple worksheets of an Excel file at the same time within the same DS job ?
If so how...please advice

It seems the only option I have at the moment is to write in to a spread sheet at a time.......

sachin1 wrote:i think it should create new .csv file for each of file creation link or transformation.

Hi, I am trying to write in to multiple worksheets in an excel file and have an error such as the following : The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. The design is that 5 output lin...

That would depend entirely on how you specify "current date" and how the database server handles that. For example, if you specify it as "job start date" then there's no way it can carry over. ... The current Date is specified as I had given in the sample above. So in the DB2 st...

I have a job that extracts from certain table based on the current date and loads it on to a table. sample: select A.aaa,A.bbb from table A where current date = date(send_dttm) + 2 days; Last night my job started at 23.45 pm and finished at 00.15 this morning. I have checked my extraction and loadin...

Hello Ray, The problem was due to the fact that there weren't any indexes created on the base tables besides the defaults. We were suggested to use some indexes which may boost the performance by 80%. Also on the Loading part as I mentioin earlier the array size is set to 1 and transaction size set ...

Hello Thanks for your responses.... The lookups are all hash files.....There is no option to input the array size in the source stage. If you are referring to the target then I used 1 as an array size inorder to capture rejects. during the monitoring tool I noticed that the extraction was done at a ...

Hello, My DS job with the following settings took about 5 hrs for the extraction and Loading which also includes lookups and some calculations. Please advice what parameters I should change to get a better performance. My Design is summarized as follows A DB2 Stage : does a multiple join select from...

Hi, I am having a problem doing a delete in the before sub routine. The source is a sequential file and the target is a DB2 stage. The job does an insert/update depending on the source. Table A A1 B1 A1 is the primary key of Table A B1 is a foreign key. When I try to update Table A for eg with conte...

Hello,

I need to enhance my skill set and just trying to find out if anyone has suggestions to lead to a successful Datawarehousing career...

Thanks