DSXchange

Hello David, we use Rowid for INSERT, UPDATE and DELETE (Change Data Capture with Oracle LogMiner). Use as Datatype VARCHAR2(19). The MetaData Import give you as datatype Varchar2(10). You must manually correct the length to 19. Worf fine with DataStage 4.0 and 5.1A on HP-UX. regards Udo David Barha...

No, but you should probably receive them into DataStage as strings using ROWIDTOCHAR and then use CHARTOROWID at the other end. The danger you face is the two actions (retrieval and use) may not occur in the same transaction. The ROWID may not be valid by the time you try to use it if updates to tha...

Has anyone tried passing Oracle ROWIDs through DataStage and then using them for an UPDATE or a DELETE?

This is a topic for an orphaned message.

Ascential do have this course, though not yet regularly scheduled and therefore not on the web page. Contact Ascential with your interest. (It IS scheduled in Australia/New Zealand/Asia Pacific). Ray Wurlod Trainer, Asia-Pacific region IBM Informix Education Department Level 22, 6 City Road Southban...

This is a topic for an orphaned message.

Hi everyone. Got this problem of hung process on NT server housing DataStage 4.0.3. Getting process hung on the server for days when users insist they log off. Anyway to check from UV the Job and Project names of each process so I could at least have something to work on? What can Operator permisson...

thanks to all for the assistance. as it turns out, ascential support indicated that there is a known Gtar regarding the BCPload stage in that it may display the Date error message. Im still having a problem completing the load, but at least it is loading something. Here was the work around that Asce...

And funnily enough, the definition of CAPITALS is: Oconv(%Arg1%, "MCT") So, to avoid remembering the conversion format string, CAPITALS is the way to go. Thanks for the note, PKM -----Original Message----- From: pavan.marpaka@ascentialsoftware.com [mailto:pavan.marpaka@ascentialsoftware.com] Sent: W...

Also the built in transform CAPITALS will convert initial characters of a word to capitals. -PKM -----Original Message----- From: David Barham To: datastage-users@oliver.com Sent: 4/9/2002 6:44 AM Subject: RE: Oracle initcap equivalent Try this (I havent tested it, but it is straight from the help) ...

You may find the CAPITALS Transform an easier-to-remember name (it actually does exactly the same thing as Davids answer). One of the benefits of Transforms is easier-to-remember names for arcane functions. Ray Wurlod Trainer, Asia-Pacific region IBM Informix Education Department Level 22, 6 City Ro...

Hi It is obviously that you are attempting to insert data to datetime datatype in SQL Server table, It is not very help to just convert datetime data format in Transform, as SQL Server cannot accept the formatted data(like 2002-10-30 00:00:00.000) as its datetime value under your current situation. ...

The most usual cause is improper manipulation of job handle variables. Correct techniques for job control routines are taught in the "Programming with DataStage BASIC" class. Ray Wurlod Trainer, Asia-Pacific region IBM Informix Education Department Level 22, 6 City Road Southbank, Vic, 3006 Australi...

Someone correct me if this is wrong but doesnt SQL Server use milliseconds? I think you should just append a ".000" to your timestamp column values to get it to milliseconds. Good luck! -Ken --- Himanshu Patel wrote: > Help Please, > > > I am attempting to insert text rows to SQL Server > using the ...

Help Please, I am attempting to insert text rows to SQL Server using the BCPload stage and am encountering problems. THe error read "Date fields must be defined by the YMD format". All of my date fields are defined at YMD ( 2001-11-30 00:00:00) ( timestamp included ) is data is present in the date f...