DSXchange

chulett wrote:I'm running 7.5.1A. Smells like a 7.5.2 bug and maybe something they fixed in 7.5.3, but you'd have to ask IBM that to find out. ...

Thank you chulet.. i will.. :D

chulett wrote:I'm running 7.5.1A. Smells like a 7.5.2 bug and maybe something they fixed in 7.5.3, but you'd have to ask IBM that to find out. ...

Thank you chulet.. i will.. :D

Mine sure won't behave in that manner. What exact 7.x version do you have? :? ... 7.5.2 i sent the data to a seq file with wrong constrain(link deleted) and other file with the correct constrain (updating with new changed link name) this is behaving correctly the other one is not, it is updating ev...

It should have been changed automatically and if it hadn't it wouldn't compile, so more than likely something else is going on. ... No the link name in the constrain remained the same it did not change.. but still the job is able to compile and run...it still shows that there is an error when i cli...

Hi All, i have a constrain in the transformer which allows only the values like "ABC" from a column.(e.x user_defined_routine(dslink.col1) ="ABC") no reject link is present. this was working fine. when i moved the job to test server i changed the input link name from "dslink...

Thanks for the reminding... i forgot that i can use the column Propogation..

Hi All,
Is there a way where we can extract the data from source table to target table with out using the metadata. using only table names and connection varables.


kris

check the properties tab in the FTP stage look for column delimiter,escape charater

As Craig said can you place the .dsx somewhere in this forum so that we can have a look at this wierd problem.

As Craig said can you place the .dsx somewhere in this forum so that we can have a look at this wierd problem.

Thanks All, Assuming both the results give the same output . iam sorry for posting wrong way. iam just intrested in knowing how the internal process works is their any kind of documentation links or .pdf where i can know how the datastage processes the incomming data with the stages. thanks once aga...

Hi All,

Is it good practice to do transformation into one variable
e.g trim(ereplace(DSLINK.col1," ","-")
or do
trim(DSLINK.col1)=variable1
ereplace(variable1," ","-") =variable2


how does the process work in both the cases

thanks
kris

use row merger to get the output u specified and the delimiter would be ,

if you can post the queries we can think of writing the query in diff way so that it can processed quickly, if possible please post the design also.

It's unhelpful not having the exact error message. Chances are that you're trying to do too much with two few stages, or even too few jobs, and perhaps getting locking issues in the database. Stag ... ray i think he is loading the same table in the etl twice which is causing the etl job to hang!!!