DSXchange

ftp://servername/folder1/Data transfer/Data load/New files/Files to Load/Filename.csv

Ray,

I gave full file path for URI.

Under connection I mentioned:
ftp command :ftp
username: user id for windows server
pasword: password.

can you help me anything with details above..I am confused on why its not connectig?

nsm.

I wanted to read file from Windows2000 server and write it into DB2. My job design is like FTP Enterprise stage----->Transformer--->DB2/API stage. Below are the errors I got . I gave userid, Password and gave full path for URI. >##E IIS-DSEE-TFOP-00020 15:13:43(006) <FTP_Enterprise_11> Error occurre...

Use Trim function

Hi all,

I am using ODBC enterprise stage to pass rejects to a Join stage and then doing my logic.

Join stage is failing when I have no rejects coming out of ODBC enterprise.

How do I overcome this? and I don't want to split the job in to multiple jobs

Thanks
nsm.

thanks all.

We spoke to DBA's and had ID columns disabled as IDENTITY columns.

Ray, I kind of guessing you didn't read my previois post detailing why I have to read those ID's again. IF you did and if I Overlooked something let me know. Vinnz, the function you mention can be used with in a database procedure or if you are using JDBC you have a way to do the similar but not fro...

Mike, When an IDENTITY column is defined as "GENERATED ALWAYS" Database can only create them. To answer your point of generating ID's shared between applications is kind of no, Bcoz I am doing conversion and after conversion there is another application inserts data in it. but at conversio...

no..the ID columns in DB2/UDB are IDENTITY columns.

Hi, I have a requirement to maintain Legacy IDs and new Target ID's for all the legacy tables in a cross-ref table. These Target ID's are IDENTITY columns in DB2/UDB. The only way I know to get the ID columns from target tables is: After populating each table in target with src table values, create ...

Hi, My database guys wanted to write data into an XML string in the database. For ex: Key from Source will stay as Key in the target but all other attributes go as an XML String. I think its doable but wanted to get opinions if anybody faced issues with it and what do I use : XML Transformer and XML...

when tried connecting to Sybase as a source or lkup(Via ODBC Connector) I get no issues. Is it still to do with Env variables?

nsm.

Hi , I tried calling a Sybase stored procedure through a stored procedure stage and below are the errors I get: Stored_Procedure_3,0: Error: Could not load dsstpsyb.so Stored_Procedure_3,0: Error occurred in call to ORPHCallActivePluginInitialize(). Please suggest on what causing this..My guess is &...

As I didn't have Sybase stages setup, I can't even test Sybase OC stage vs ODBC connector. I can see them in the palette but Sybase databse conectivity is setup as ODBC connection so I can't connect to Sybase using SYBASEOC. what I am trying to get to is performance wise and usability wise which wil...

Thanks Chulett, Ray.

I have source as Sybase and Target as DB2.
So are you suggesting to use ODBC connector, ODBC Enterprise instead of sybase Enterprise, Sybase OC(not sure what this is)?