DSXchange

Is there a way by which the mentioned issue be addressed.

Thanks for your time.

Thanks for letting know the options.

Hi, There are 100 parallel jobs which needs to be run. They can all run independently as their source + target tables are different in each job. The records processed would be bit on the higher side and not sure on how many jobs can be run simultaneously in a sequence. Is there a way in which I can ...

Hi, I am using DS 8.5 and when I give any user-defined SQL statement in the ODBC statge in "SQL Select Statement" it displays a warning like Invalid Property Value Expecting :Other input Even though it is during user defined query is mentioned the job runs fine without issues. Just curious...

stuartjvnorton, that was fantastic, it worked when the property was given as Databasename.dbo.table

Ray, Sorry I did not understand your question.

Thanks

Hi, Unable to prefix schema name in the ODBC stage which is target (only insert records), the target database is MS SQL Server. The way it is given in the job is #DBname#..tablename and when run it errors out but when given as only tablename without prefix then executes fine. Is there any way by whi...

Hi, We have been converting the Sybase source to SQL Server source in our DS parallel jobs (DataStage 7.5.1) and we encountered an issue when tried to convert the stored proc. used earlier in Sybase to now with the SQL Server ones. It was used with Stored procedure stage (STP) in the jobs, unfortuna...

Used ODBC to connect to SQL Server DB after the ODBC configuration is done.
Thanks all.

Hi, I actually need to use MS SQL Server stored procedure in a parallel job, earlier stored procedure was in Sybase so STP (stored procedure stage) was used. The strored procedure actually returns 2 columns which are passed to join stage and this is one of the source stages. Appericiate any help on ...

Also the NLS is not installed

Had the NLS_LANG variable in the DS administrator (user-defined) and used the parameter in job and passed the characterset to it.

Hi, Could not load string with special char. into Oracle table from Sybase. eg. Histoire d’Or (value from Sybase) when loaded into Oracle it is with inverted question marks as it is umapped. Oracle characterset - WE8ISO8859P1 Sybase characterset - ISO 8859-1 (Latin-1) - Western European 8-bit...

Is there a way how we can fix this?

Hi All, From source (.csv) file I have the date column value as 16-Dec-10 and when I try to load to Oracle with StringToDate(Trim(Date1),"%dd-%mmm-%yyyy") error is thrown. Transformer_130,0: Conversion error calling conversion routine date_from_string data may have been lost The target Ora...

Hi, I am fetching values from Sybase and loading it into Oracle tables. One of the columns in the table is float datatype and when it is loaded into Oracle it rounds it off. eg. -39238453.3 is getting loaded as -39238500 Sybase -> transformer(map cols) -> Oracle In source as well as target I am usin...