DSXchange

Unfortunately, in the log file the number of loaded lines is not in the last line! But somewhere in the middle of the file. I feel a little uncomfortable with this Output in the DSExecute command - Call DSExecute("UNIX", CommandToExecute, Output, SystemReturnCode). It is not equivalent to the log fi...

Hi Warren, have you tried to use FTP stage playing with "FTP Data Connection Mode" property on the Outputs/Inputs Properties tab? Hope this will help you! Riccardo ----- Original Message ----- From: To: Sent: Friday, March 22, 2002 10:09 AM Subject: RE: Unix to NT file transfer > If you can mount th...

If you can mount the NT directory on the UNIX-box it shall be done. Best regards Klaus -----Original Message----- From: Warren.P.Kalsow@HealthPartners.Com [mailto:Warren.P.Kalsow@HealthPartners.Com] Sent: Thursday, March 21, 2002 11:21 PM To: datastage-users@oliver.com Subject: FW: Unix to NT file t...

Hopefully someone whos actually done this successfully will be able to respond with the secret. Even though you get a metadata mismatch in the data browser, do insert operations now work? Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, Southbank Vic ...

Timestamp, however, while I tried to view data, it issued warning message: DSBrowser1.DSLink1: DSD.BCIOpenR results of SQLColAttributes(version_timestamp) gave MetaData mismatch COLUMN.TYPE Expected = Timestamp Actual = Unknown > -----Original Message----- > From: Raymond Wurlod [SMTP:wurlodr@au1.ib...

What do you get when you import metadata from the SQL Server table? Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, Southbank Vic 3006 Tel: +61 3 9626 6624 Fax: +61 3 9626 6622 Notes: Raymond Wurlod/Australia/IBM Email: wurlodr@au1.ibm.com

Hi, Ray I can convert the source data to be yyyy-mm-dd hh:mm:ss.sss format without any problem in Transform stage. However, I still cant insert/update the target column with Datetime datatype, see the error message below: [Ardent][SQL Client]An illegal SQL data type was supplied| I think I should us...

From the Help on the Ora OCI 8 stage for Array Size: Larger numbers use more memory on the client to cache the rows. This minimizes server round trips and maximizes performance by executing fewer statements. If this number is too high, the client may run out of memory. The memory used is affected by...

How about a stupid answer? Microsoft, for reasons of their own, insist upon milliseconds in a timestamp (which, for reasons of their own, they call a DateTime). Your job needs to craft a format such as YYYY-MM-DD HH:MM:SS.sss The easiest way to do this, in the Transformer stage output column derivat...

If memory serves me correctly, the ODBC stage for SQL Server (we use it, but only as a source, so I dont write data to it) handles time down to 1/1000 of a second. In the derivation for the SQL Server date, try appending the extra decimals of a second, for example: in.datetimefield:".000" -----Origi...

Hi, May I ask a stupid question? As it is the first time I am trying to insert/update data into table in SQL Server by DataStage. In this table, there is a column with Datetime as datatype. However, my source column data format is "dd/mm/yyyy hh:mm:ss", Can anybody tell me how I am able to convert a...

Technically, the Stage can only handle files that are local to the server that DataStage is running on. Youve got to find some way to get the file over there, or at least make it look like it is over there. If FTP is out, how about something else... rcp? Named pipes? NFS mount? -craig Warren.P.Kalso...

> With the DataStage engine on Tru64, is there a way of specifying that > the directory on a sequential stage should be on a NT server? > > The destination NT server doesnt have ftp services available. The > Tru64 system is running DataStage 5.1 and also samba 2.2.2 > > > > Warren P. Kalsow > System...

This is a topic for an orphaned message.

Create another output link from the Transformer stage that is supplying rows to the stage type that is inserting rows into SQL server. Mark this new link as handling rejects. That is sufficient to capture the rows rejected by the database. You can create columns on this new output link to contain di...