DSXchange

vercama,
create a sequence
1.jobacvity stage ----first write the max_date to file.
2.execute command activity state ----open the file using cat command.
3.take the prameter from second job.

jobactivtystage--->executecommandactivity------>jobactivitystage

chulett,
thanks for the reply.

just rested it.
shows the same thing.



Regards

Dear Experts, i have xml tags in a table( sqlserver). the datatype is XML. when i imported the table definition it imports as longNvarchar in datastage and when i click viewdata, i get a error message saying datatype not supported.. how can i read xml datatype from datastage?? once i read i can pars...

throbinson
thanks for the reply.
Is it just that get the column in which i have the xml tag and parse it in xml input stage???

thanks

experts,

i have a question.
i have a table in which a column has xml tag/message.

is it possible to parse the xml message/tag to columns???

appreciate any help.

Regards.

does both the operators use the scratch space for sorting the data in both cases or only the sort uses the scratch space and transformer uses the resource disk???

regards.

thanks for the Reply.

can you be more specific ???



Regards.

dear experts,
i have a question.( parallel DS8/AIX5.3)

what is the difference between
sorting using a sort stage and
using a transfomer with hash partioning and checking the sort checkbox??


appreciate your help,
regards.

odbc enterprise stage loads normally..

Thanks.

now i am testing with odbc enterprise stage instead of odbc connector..
i should update with the result..

thanks anyway..

my bad, when starting to write a post i selected parallel only ..some how wrong selection... job is parallel.. here is the generated sql on SQLSERVER side.. ODBC_Connector_1,0: [IIS-CONN-ODBC-000105] Connected to Microsoft SQL Server, version 09.00.57867 through driver VMmsss22.so. [IIS-CONN-ODBC-00...

Thanks!!!! to test here is what i did i selected the data from oracle table like this select * from table_name where load_date = to_date('2007-12-31 14:29:29','yyyy-mm-dd hh24:mi:ss') and in transformer mapped to odbc and to a peak.. the specific column is loaded as 2008-12-31 14:29:29.000 in sql se...

Tanks for your response.

uses generated sql statement.
and in transformer derivation i just mapped from timestamp to timestamp.

nothing else..

gurus, i have a job that loads a sqlserver table. i have Oracle Enterprise ---->Transformer----->Odbc Connector. i am loading a table in Sqlserver using Odbc connector. during the load process i have oracle date filed which i am reading as a timestamp and loading as a timestamp to sql server ie. as ...

lstsaur,
thanks a bunch for your step by step procedure...
i will try this. i see an example in the documentaion.but i didn't know that i have to comiple those example codes and put the classes in the mentioned directory.
your explanation in enlightening

Regards.