DSXchange

hi kduke,

Again i got another error when i try to open the job in Designer
Error Calling Subroutine Error Calling subroutine: *DataStage*DSR.PLADMIN[Action =4];check
DataStage is set up correctly in project edw
[Subroutine failed to complete successfully[30107]]
what does it mean?

hi, I have again ran the command DS.REINDEX ALL in DSAdmin, after that jobs are working fine without any problem but i was not able to see the job's log file in director. what need to be done to get that job's log file. when i open the same job in desiner it is saying that "Failed to open RT_LO...

Hi sainath I have executed the command DS.REINDEX ALL on current project edw via DSAdmin, but still problem has not solved, getting error "cannot open the execute file CONFIG52" and log is not showing for all my existing jobs particular category. is there anything else i need to take care?...

Hi I am not able to see one of the parallel job's log file and it is giving an error "Failed to open RT_STATUS42file" when i open DS Director of the same job. then i closed DSDesigner and Director and again opened the same job in the designer, when i open director now it saying an error &q...

Hi Sarvanan, is this command works out for my solution if i put in before job subroutine as ExecDOS copy /apps/Ascemtial/Projects/IDD/*.txt /a /apps/Ascential/Projects/IDD/ADTest.txt /a or shall i write a shell script and execute in before job subroutine ExecSH merge.sh which one of the above comman...

Hi roy,
i am not understanding file pattern here.
currently i don't have ds parallel job developer pdf .
can you please explain in detail.
Thanks

For one of our integration points the inputs will be a set of files sitting on a Unix server. We would like the DataStage process to input and process all of the files contained in the directory. Can anybody please advise which stage should we need to use to retrieve and process multiple text files ...

Hi,
Can any body explain in detial on what is difference between SAS Stage and SAS dataset.
What are their actual use and what sort of source files do we need to give inputs and what are the actual contents needs to be passed to extract the data from SAS.

Thanks,
Pongal

Hi, I have requirement in such a way that we need to integrate data between SAS and Oracle database. Currently we are using Java API'S to manually integrate SAS - Oracle by just comparing the data between SAS and Oracle tables data and we are doing insertions or updations. We planned this Integratio...

some more info i am updating here. when i press view data of DB2_UDB_API Stage have parameters as environment variables for DSN , UserID, Password, it is connecting to database and displaying the records properly. But, when i try to run the job, it is giving the error Warning: DB2_UDB_API_OWPYDATA_F...

When i remove #, it is giving the error Warning: DB2_UDB_API_OWPYDATA_FO901: Unable to connect to DB2 server '$DEV_SRC_DB_SERVER'. do i need to create these Environement varaibles in Parallel Environment in Enviroment Variables button of DS Administrator for a particular project when i try to pass t...

I have created Environment variables like DSN,UserID,Pwd at Project Level in UserDefined variables. My job is parallel job, when i try to pass those enviroment variables as parameters to the parallel job, job is aborting saying that Warning: DB2_UDB_API_OWPYDATA_FO901: Unable to connect to DB2 serve...

Thanks chulett
but the prefix number 10683 in 10683 (1997-03-31) stands for what ?
how can i correlate 10683 with 1997-03-31 ?

Hi, I dont have any knowledge about cobol date formats like WS-DATE-CCYYMMDD. I have seen one date field values in DB2 table with datatype Date like this 10683 (1997-03-31) 9658 (1994-06-10) Here i am not understanding the format of the date value above mentioned. My task is, i need to first convert...

How do we define Environmental variables at project level. I have a requirement to set Enviromental variables like DSN Name,UserID,Password,Table names,Absolute Paths etc and pass them as job parameters for each job. here Password should be Encrypted. Shall i define all the above environment variabl...