DSXchange

Teej wrote:To run multiple instances of DataStage PX jobs, you MUST upgrade to 7.0.1. It is not possible with any lower versions.

-T.J.

No, Teej, It is available in 7.0 version as well.. I use it.

i guess what Vincent suggests sounds doable to me. We could code a call DSExecute, to get the value you need, then use a DSSetParam within the routine itself to set that value to a job parameter, in the job control. Since this is at the job level, you could directly use that job parameter in the sur...

though i am almost sure that there might be a typo in the remote server name, userid and password values, can you please copy-paste the error message from the director log... so we can try to figure out the reasons for the error..

Lookup stage has a property called 'IF not found' which you have to set according to what you want, if you use 'Continue' it will send the record along to its output link with Null or a 0 depending on that column format. I did a similar thing earlier, where lookup was on a number column, so it retur...

did u specify the QUOTE property on the sequential file stage as 'double'. This tells it that the column will have leading and trailing double quotes. Try this, write a simple test job with source sequential stage to read this input, and define the quote property as double. Use a transformer to dire...

[quote="sim"]By the way, 'Transaction Control' is not displayed on the stage properties. I think, we have to do something with administrator to set 'Transaction Control' in PX.[/quote]


yes, it was discussed on this forum before.. check this viewtopic.php?t=86747

Thank you Kim, for the code. I did write a similar routine, but didn't know where to call it from. As i said i have no source. You mentioned that i could do it in job control. I have never written any code there for any job exept to run some UNIX commands, so i didnt exactly get the big picture. And...

Guys, please throw suggestions as to how this can be achieved.. i need to populate a code table with values that have a domain and range specified and there is no source as such required for it. For e.g., i need to populate the table with 3 cols 1) id - can use a key generator or sequence, no proble...

you could use the after job sub routine. There u could use ExecSH routine to call a shell script that just calls the stored procedure... hope u get the idea.. or look at this to understand what to write in shell script..send the database userid, pwd and connect string for sqlplus as parameters to th...

in version 7.0 DS Administrator, there is a 'Protect Project' option, available for each project. And enabling that will make all the jobs in that project read-only and cannot be modified... dont know if this option is available in ver 6.0 to try it out, connect to DS Administrator, select the Proje...

[quote]Sucks to be you on this project. [/quote] 8) actually, i am totally loving this project, coz it poses so many challenges, i am actually learning a lot about using datastage effectively. If it were like the regular datawarehousing projects, that i worked on earlier, i guess we do know well kno...

..and forgot to add.. that the target database is going to be the backend to a web based aplication, which is being built and tested simultaneously.hence the decision to use oracle sequences.. so we dont cross each others tracks in integration.. we had our own sequences until development.. but in in...

:) Well, actually we do have the prestaging area, but that was to retrieve data from numerous and varied sources into oracle tables, where it is transformed and cleansed. Then we are populating the target database which is highly normalised unlike the typical datawarehouse projects. Hence the constr...

I have been trying to analyse the pro's and cons of trying to implement a job in which i populate both parent and child tables (oracle). The reasons for wanting to do it are 1) high volume of data 2) the child table needs to be populated with just the parent id and some default values to its columns...

i had tried something similar, but using a server job, so see if you can work it around like this. My requirement was that i had input detail records in the form SNo Type Amount 1 TypeA 123 2 TypeB 456 3 TypeA 789 4 TypeC 999 ...and so on Needed output to be in this form 1 TypeA 123 3 TypeA 789 TR T...