DSXchange

Hi,
Varchar2 is for that,it save spaces.
For example "DataStage " will store as "DataStage".
Why you want trailing blank spaces in your target table?


regards
kcs

Hi, Sorry for responding late. After we got user2 7623 Sep12 .......FIN_WAIT_1 . we restarted the server. When we check for netstat -na |grep 31538 ,it returned nothing. DS is working fine now. Did you check to see whether pid 7362 had any child processes before you killed it? Killing a parent can t...

Hi Kumar,Craig Thanks for your reply. We exeute ps -fe | grep dsapi_slave | more to find the process id of this connection. we got user2 7623 Sep12 .......ESTABLISHED. We kill that process(7623) through root. When we execute netstat -na |grep 31538,we got user2 7623 Sep12 .......FIN_WAIT_1 . Does it...

Hi Parag, Now i have to device a logic such that if i am running a job in Feb end then the amount for feb should be difference of feb amount and previous month i.e. jan amount (Feb Amt - Jan Amt). Is it always the difference between the current month and the previous month? ie is this logic applicab...

Hi, We want to Restart the DS Server. We know that everybody has logged out. When we execute netstat -na |grep 31538 command, we found that one user is still connected to DS. tcp XXXXX 100.200.20.30 100.200.10.15.1740 .....ESTABLISHED . Iam sure that nobody is using 100.200.10.15. How is it possible...

Hi,
There are many ways.
One of them is by using SecondsSinceFromTimestamp
Try to get minimun(Timestamp difference between given date and sysdate).

regards
kcs

Hi parag.s.27, Now i'd implemented this logic with system date successfully, but the OCONV() function is not working for direct date supplied from a source file. It should work. can you give some more details about, your source data format, expression for conversion and output you got . regards kcs

Hi,
Try @Outrownum/@Inrownum function to get required output.

regards
kcs

Hi Nick,
After Searching the forum for Parallel job reports failure (code 1),I got this linkviewtopic.php?t=92186&highlight=reports+failure.


regards
kcs

Hi Nick,

I just wanted to convert the source data into an integer using iconv

Modify stage will do that conversion.

regards
kcs

Hi parag.s.27, welcome aboard.One more solution You can find the day of Delivery_Date by using Oconv(Delivery_Date , "DWA") Declare Stage variables Delivery Date ---S1 Delivery Date+1 ---S2 Delivery Date+2 ---S3 In your column Derivation , If Oconv(Delivery_Date , "DWA") ="S...

Hi, Search the forum for Creating a secure routine .That post will elaborate(By Ray) on You can create routines as external UniVerse routines, globally catalog them and create interludes to them. This is a lot of work, probably for no great gain. And will it work once DataStage is no longer based on...

Hi Anupam,
Try this link to create
Secure Routine


regards
kcs

Congrats DSX, on reaching yet another milestone.


regards
kcs

Hi Vindy,
try this link,
http://dsxchange.com/viewtopic.php?t=95 ... 45df76f2e4

regards
kcs