DSXchange

thanks kryt0n i will go with your suggestion that makes more sence to me !

NLS is not enabled.

I saw the data through peek state:CA length:2

Can anyone please provide some pointers to check whats happening here!

Thanks,
Aruna

hi All, I have a cloumn called state whose datatype[varchar] length[2] i have following job: Oracle enterprise>>>> transformer>>>sequential stage in transformer i am padding the columns with spaces to create a fixed length record something like if IsNull(lnk_db_xfm.State) then PadString(""...

ugradation worked thanks chulett!

i don't see that's happening in version 8.0

i don't see that's happening in version 8.0

yes you are correct i can do that and reffer them using $PROJDEV. I just wanted to know what value addition parameter set has done in 8.0 & above. anyways thanks for all your replies.

changing values in dataset like suppose username. By reconfiguring i ment in order to reflect the new user which is changed in the same parameter set recompilation is not working instead i have to go in job parameters and select the same parameter set again to relect the change!

I meant if value set's values are changed. It's not reflected in the job unless you reconfigure & recompile the job with the same parameter set. My understanding towards parameter set was it's a centralised component where any changes made to value will reflect to the jobs using that component. ...

hi, Please clarify the usage of parameter set in datastage 8.0 & above. I was hoping that this will work independently and any change in this component need not require recompilation of jobs using this. But it never happened we have to recompile or even worst sometimes reconfigure the same compo...

i got it working by separating all the key words as job parameters as ds can't read spaces between keywords like "between startdate and enddate"

hi, my scenario is Oracle enterprise>>> seq file this needs to be run in 2 modes daily & history, my plan to reuse the code with multiple instance and passing parameter from parameter set query used is select datecol1, col2 from table where datecol1=psDate.jpDate Daily mode Date=/=/'$1/' $1 is d...