DSXchange

As per Ray's comment StringToTimestamp() function was not accepting value as '0000-00-00 00:00:00' and hence read the column as a varchar and performed the Value to Null conversion. Thanks for the advise

Hi , I am reading a Timestamp column from a flat file but it comes with some default values as '0000-00-00 00:00:00' which i have to convert that as Null before i try to insert them to my oracle database. The design of job looks like below Sequential stage ----> Transformer -----> Oracle database(OD...

Hi,

The speculation was correct. The diskspace on /dsprojects was full and hence the error.

Hi,

I am using dsadm to export and import in both of the dev and test environments.


Is there any specific directory that i could check for the permission issue in Linux environment

Hi , I am trying to promote a server job from dev to test environment.I have tried the options export Job executables without design and Export Job Design With Executables i am getting an error while i try to import the server job from the dsx file Error while creating job Test_job Error on CREATE.F...

Hi,

Thanks for the clue and it helped to resolve. I could now see process on both of the nodes using ps -ef.

Hi Sorry, i have copied the code wrongly. Here you go with the correct configuration content that i have deployed in my job. main_program: APT configuration file: /opt/IBM/InfoServer/Server/Configurations/dev2.apt { node "node1" { fastname "DatastageETL" pools "" resour...

Hi ,

Yes ...After saving the file, I have parsed the new .apt file and it came clean without any errors

Hi I am doing a SCD Type 1 change capture between an oracle table and a sequential file. Each of the after and before dataset links would have roughly 65 million records for comparision and currently i have a one node configuration file. For sample testing i have created two nodes ( node 1 and node2...

Do i need to turn this off ..? would this be in anyway helpfull to me ..?

Hi ,
I am importing an oracle table metadata as ODBC table definition. I could see that datastage is importing the char and varchar columns in oracle as Nchar and Nvarchar columns automaticaly.

Is there any reason why this conversion is happening and any way to stop this .?

Kind help is appreciated.

Hi , I am using Information Server 8.1 installation on a Red Hat linux. I would like to see the date and time the jobs were modifed on a particular project. I believe the Datastage Manager in earlier 7.5 version was catering to this need and the equivalent of this is the Information Server Manager i...

Hi , I am yet to get that script but i believe the script would be like.. insert into Table(Col1,Col2....) Values (Val1,Val2....) I am trying to visualise the logic for just insert statements but what i was told is that the third party data provider would be giving me a complete MySql transaction du...

Hi , I have a very wierd requirement of using datastage to parse the MYSQL Insert Scripts into Column value pairs and then write it to an oracle database. The requirement comes in the backdrop of business saying that the MYSQL database is a third patry database and they can provide only the scripts ...

Hi , I am having a DB2 Server sitting on iseries machine and my Datastage 8.1 sits on a linux platform. I have tried adding contents to the uvodbc.config and the .odbc.ini files but yet to get something for DB2 into the DSenv files. Can you please advise me what should be the content that i have to ...