DSXchange

No

Hi Team

Can anyone help me if there is an option to read xml files at run time and get the output in text format

example I have five xml files with different metadat but I want the columns output which has common columns in all the xml files.

Regards
chandra

Hi Team,

I am doing an upgrade from DS7.5 to DS8.5 ,

I am getting the following error

: [IBM(DataDirect OEM)][ODBC SQL Server Driver]Unicode conversion failed

My job is reading from MYSQL and writing to Teradata

Can any one please help with the resolution.


Regards

Hi Team, I am migrating jobs from 7.5 to 8.5, I have used column XXX as BIGINT 19 , My source is MYSQL I am using DRS stage in 7.5 it ran success fully . But when I run the same thing in DS 8.5 it gives me the error Fatal Error: Fatal: Data type 'BigInt' for column 'XXX' is not supported at this ver...

I am trying to run a job activity in a sequence , on the weekdays only, I don't want to run on the weekends , i want to implement by writing a trigger in execute command stage .

Can you please help me how to achieve this

Hi Team,

I want to use the below in Execute command stage


WeekdayFromDate(CurrentDate())<>0
WeekdayFromDate(CurrentDate())<>6 but I cannot do it , Can any one help me with alternate way

Thanks

And also if I have the input as 1 and the parameter contains 12,11,21 then the index doesnt work

yeah but in the parameter we donot know how many number and of values are there and also I want to know how we can do the looping for all the set of values .

Hi Previously my source( oracle) query was SELECT * FROM <TABLE> where <COLUMN> A in #PARAMETER# #PARAMETER# is from my parameterset. Now my source has been changed to sequence file I want to filter this some where in datastage job either in transformer stage or any other stage. can you please help ...

hi Friends


I have a parameter which is having no of values in the parameter from parameterset.

#AAA# having 1,2,3,4,5,6 values( values are different for each run)

I want to use this in constraint as where column A in #AAA#

can any one help how can I acheive this in DS

Thanks

Hi Team,

I am having a sequence which is having three jobs in series. I want the sequence to wait for 5 mins after my first job runs can any one help me with which activity can I achieve this.


Regards
Karry

chulett wrote:Not unless you explain what you are doing pre/post sql and post the "following DB2 message".

I am creating some alias for some tables in pre sql and in after sql I am dropping the the alias of some other tables

Hi Friends, I am trying to load one file from as400using a db2 stage with some presql and post sql in it,But my jobs fails with the following error Fatal: [IBM][CLI Driver][AS] SQL0198N The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty. SQLSTATE=42617 DSTAGE-DB2CLI...

Hi Krishna,

I can remove it by checking generate XML chunk but I can add my own header, The header tab diappears when we check box for generate xml chunk.

Hi Ray, This is no the input column this header is generated in xml oupt stage which is my target as <?xml version="1.0" encoding="ISO-8859-1"?> where as I want it to be as <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?> which I can add i...