DSXchange

Thanks a lot it was a good idea

it is working great

i m using 7.1 can you please tell me if there is any round about way of getting the functionality

hi all we have this requirement where if a countrycode(parameter) is specified we should get the data from the table where the countrycode column in the table matches the parameter value. if nothing is specified all the data for all the countries should be retrieved we found this out and rote a quer...

hi ray That was real good thanx for the clarification i also have a few small queries in my design 1) i have huge tables(7 million records) in my database and also small tables( a few thousand records). i need to adhere to a set of business constraints before i take the data to process further. the ...

ray
can you also clear me on the assumptions i had on tables getting locked when writing but not when we are reading from them.

my 2nd post in the thread i explained my concern

Thanks and Regards
Pavan

hi andru Thanx for the reply how is it going to affect if i get across the same table in both the streams. Will there be some kind of locking on the tables???? As such i am just using the same table at both the places just for reading data from it. i was under the impression that as i am just readin...

Hi All we are working on a application which is taking 7 hours to complete. The requirement is to bring it down in 5 hours The solution to be proposed should be a DataStage architecture As such the design which is in place is a very good one. we need to use every parallel property of DataStage to be...

hey guys i just posted it to get my question across to people who see only PX forum. and unfortunetly everyone out there seems to agree with chulet. The last thread of mail says i can do it. i tried the same way but it literally took #EmailID#( Email is my parameter) and tried to send a mail to #Ema...

Hi, We are not able to pass the parameters (mail receipient, e-mail subject ) to the mail stage in the sequencer (in which we are using that mail stage). On hard-coding the above mentioned paramaters the job runs fine. However, when we pass a value to them through a job parameter - the sequencer rep...

hi all So now we got to live with the hardcoding in the mail sequencer. One round about way is to rite a shell script which does the mail functionality and call it using a execute stage in the sequencer Can you also suggest me if this works. i have DSSendMail option in basic can i use this command a...

:cry: ohh we are sure in a fix here. The parameters we are trying to pass are: The recipent e-mail addresses and the e-mail subject with the country code( a parameter) appended to the message saying countrycode:jobname failed we hitting around the multiple instance concept so same job is used for di...

hi all
we are not able to pass the parameters to the mail stage in the sequencers it is taking the parameters as hard coded values.

Doesn't mail stage support parameter passing???

it would be very helpful to us if you can send us any round about way for the same.

Thanks and Regards
Pavan

hi all we are facing a peculiar problem. we are getting innumerable warnings in the log file. we are aware of what these warning are and we are fine with the warning which are coming. we want the job log to come without the warning messages. we want to see only the info message and the fatal message...

hi all i guess i got it. the calculation i said i was doing in the transformer is something like ((col1-col2)/col2)*100 what is happening is someof the values which are coming in col2 are blank as soon as i changed it. it is working fine The error which was given by DataStage couldn't point me to th...

hi all i have this error "Attempting to Cleanup after ABORT raised in stage jbRevenue..CalcVariance" as a warning and the job is getting aborted. it was working fine in one run and it was aborting after that. The stage it is refering is a transformer and some calc are being done in the tra...