DSXchange

Hi Ray,
Thanks for your quick response,
Actually i am getting input value as decimal and i need to convert binary for business logic,
Eg: Input is 10
Output 1010

Is there any build in functuion?

Hi All,
Can please some help me , how to Convert the decimal value to binary in DS px?


Regards
Raj

Hi, We want to retrieve data from SQl server which has data type as TEXT in SQL server. The DataType specified in the ODBC stage is LongVarChar with length of 2147483647 When the data lengh is exceed 192203 we are not able to view the data through ODBC satge and when ever we try to open the ODBC sta...

If the only use of that function is to get latest key value, before your job, run another job that gets max(PRIMARY_KEY) from Table and dump it in a file: Example: File with 2 columns KeyColumn KeyValue X 123456 123456 is the MAX value for that primary key. 'X' is a hardcoded column that will be th...

Hi, You can merge two has files into 1 files by converting one files into seq file and using transformer Step :1 Convert the primary hash(file) file into Seq File Step :2 Use transformer to merge the file Seq file as input and hash files as ref O/p file will be Hash file like you final file with K1,...

Please specify what is the problem using folder satge ..are counting the records in the files.

Hi All,
I got the following warning message
PRINTER memory segment removed
DataStage Job 1285 Phantom 10693.

Again i reset the job and try to execute it went fine.

I want to know the root cause for this issue,
Advance thanks for your valuable reponse



Regards
Raj

Dear All .. Thanks for your kind reply... By using the following code + FMT function it is solved IF WKLIABUSD = 0 THEN DIV = 0 QUAS = 1 END ELSE DIV = DIV(WKLIABUSD,WKDIVI) QUAS = WKLIABUSD/WKDIVI END IF QUAS > DIV THEN Ans = DIV+1 END ELSE Ans = DIV END WKLIABUSD is the value WKDIVI is divser valu...

How would you do that with ceil ?!! Try Mod(InLink.TheColumn,10000) - 1 ... thanks for your kind reply..Sorry actualy i need if the value like below $0 to 100000 output 01 $100001 to 200000 output 02 $20001 to 300000 output 03 so if i use ceil function i can get the nearest greatest for the value l...

Dear All, I want to check the below condition... Like the value $0 to $100000 output 01 $10001 to $20000 output 02 $20001 to $30000 output 03 $30001 to $4000 output 04 etc.... So i need the equalient dataStage function for oracle ceil Thanks in advance for your help.. Regards Raj

Hi Ray,
Thanks for your answer, I will use job parameter in before SQL in OCI stage.


Regards
Raj

Hi, Thanks for reply, We are planning to set the following session variable to avoid the full table scan. " alter session set OPTIMIZER_INDEX_COST_ADJ =25; " Because some time oracle miss judge full table scan plan is better than other plan (index/range plan) to avoid this we are planning ...

Hello frnds, Due to performance, we want to Initialize the session variable in the oracle only for the particular Project Is there is any way to trigger the oracle parameter for particular project? Because our DS project has lot of OCI stage ,so Initialize the oracle session by using before query in...

Hi
Do you want to execute the jobs parallel ?
You can execute them parallel through sequencer.
Just put all jobs parallel in the sequencer and than trigger the sequencer


Regards
Rajkumar

Hi Friends, Due performance , We have idea to migrate the server job to parllel jobs. I have few doubts on this. 1.Is it possible to migrate the server jobs to parallel jobs with out any change in the code? 2.If so the migrated code will use the parallel jobs features. Thanks in advance Regards Raj