DSXchange

Hi There, I have a DATE with format of DD/MM/YYYY HH24:MM:SS I want to move this from ORACLE to FLAT FILE and then to FLAT FILE to ORACLE(BULK LOADER) can anyone help me what data type( either timestamp or date) shoulb be used through out the job.. I am getting this error ORA-26041: when Im using ti...

Use a TO_CHAR() on the select with a mask of 'YYYY-MM-DD HH24:MI:SS' and use a Datatype of Timestamp in the job all the way through. ... Hi there. When I say timestamp it is already TO_CHAR why need of TO_CHAR I also tried TO_TIMETSAMP but then the job gets success but my error file says "ORA-...

Hi There, My source data is in the format of DD/MM/YYYY Im writing ORACLE to FLAT FILE and then in the next job FLAT FILE to ORACLE(BULK LOADER) my examples are like this ORACLE FLATFILE FLATFILE ORACLE(BULKLOADER)ERROR 02/02/2009 14977 14977 DATE DATE DATE literal does not match format string In th...

As Ray has already stated (twice) in this thread, the IPC subsystem is not involved. Is your project directory full? Is the log file somewhat over 2Gb large? If neither, then perhaps the file is corru ... Hi there, Can you please let me know how to involve the IPC subsystem Im new to admin tasks. T...

ray.wurlod wrote:The first requirement is that you have an IPC stage in your design. I don't think you do. ...

I have enabled row buffer and selected inter process for the job and alos increase the buffer size to 500 kb still there is the same problem can anyone help me please

You don't. DSD.WriteLog is an internal routine (this is indicated by its "DSD" prefix). You look at the arguments you gave to whatever it was that you used to write an entry into the log (for exam ... Hi wurlod I know I dont have membership I will buy one very soon can you post your messa...

prasad.bodduluri wrote:you can increase ipc stge buffer size try once, i think it will solve your problem

Hi There,

Can you please tell me where can i find ipct stage buffer size, Im writing flat file to oracle using bulk loader

Hi Friends,

Im getting this error where do I look for line 315 and how can anyone help me please.


From previous run
DataStage Job 195 Phantom 16230
Job Aborted after Fatal Error logged.
Program "DSD.WriteLog": Line 315, Abort.


Thanks

Search for IConv and OConv. ... Hello there I can use IConv and Oconv but there are loads and loads of date fields it kills the performance. I want the data*(02/02/2009) from oracle to be written to flat file and then from flat file to oracle. when I am writing from oracle Im using date datatype in...

In case 2, input is date and not timestamp. So it fails. In case 3, the output appears to be julian date. Can you explain what you expect to see. ... Hi friend My oracle data is like this 02/02/2009 and I want to see the same in output 02/02/2009 what datatype shall I use in oracle stage and what d...

Hi friends, I have migrated some jobs from DS 7.5.2 to DS8.1 These job extract data from oracle and write to flat file But my job is having some date fields ex case 1) input(timestamp) : 02/02/2009 00:00:00 output(timestamp) : 02/02/2009 00:00:00 this is successfull case 2) input (timestamp): 02/02/...

do a "reset" on your job and then look at the entry "from previous run...". Most likely your before job code (perhaps the job control) is calling things that don't exist or haven't been loaded into th ... Thanks a lot I have done resetting that showed me the error my before job ...

chulett wrote:Details please! How exactly are you 'passing' the parameters thru a file? ...

Im calling a before job subroutine and that inturn looks for a file

Hi Friends, I have migrated a job and a routine to DS 8.1 from DS 7.5.2, When Im trying to run the job with hard coded values of database the job is running successfully. But when I pass the database parameters thru a file by calling before job subroutine the job is failing and logs show much detail...

Hi friends,


I managed to login as administrartor in 8.1 and created a project but the same project is not getting reflected in UNIX server.


can anyone help me on this.

Thanks