DSXchange

i have a need to call the db2 udb stored procedures from datastage. is it possible from datastage? which stage should i use for this? also can i execute the stored procedure for each row that i am processing passing some of the columns and get back some output values?

TIA

still I didn't get any good answer : I need to implement AES algorithm.. I was looking if somebody has implemented encryption in datstage while doing the data loading. Like having the algorithm in an external program (C, C++, etc) and calling it from ascential. Is this possible? Else is there anythi...

I need to implement AES algorithm.. I was looking if somebody has implemented encryption in datstage while doing the data loading. Like having the algorithm in an external program (C, C++, etc) and calling it from ascential. Is this possible? Else is there anything that supports encryption(Oracle ha...

Any approaches for encryption of data using datastage?

T.I.A

thanks for all the inputs.. let me put more clarity in what i am looking for.. my requirement is to load around 10 millions of record from flat file to UDB database. on the way i will need to get some info from a DB2 table in another mainframe machine. now this DB2 table which is to be looked up is ...

I have been going through some of the postings in this forum on look up in general and I am trying to make some conclusions. Please put in your expert advise. If I have to do a database look up (eg. against a oracle table) in server job, there is no separate look up stage and the oracle stage can be...

can you please throw some light on the named pipe that datasatge supports? Is there a stage for this? If I use this will it not support the parallelism? Also the ftp stage in PX. How does this work? Can I use this as an input stage and will datastage manage the ftp connection and data pooling so tha...

Hi, I have a requirement to bring in a flat file from one of the mainframe machines to the Datastage ETL in Unix and use the file as input source for the ETL job. I am thinking to do this using an FTP process to bring the file across to ETL unix server and use it as the flat file input source. But i...

I have loads from two separate companies and hence they are totally independent. So my requirement is to generate unique numbers for each record. But the target table is same and I have three separate jobs doing the inserts to the target table simultaneously. Hence they should not get the same seque...

One more reason why I want a unique hash generator is I need to run more than one job which simultaneously inserts into the table(data from two different sources). If I use hash generator this will not be a problem. But if I use one up sequence then there will be duplicates. Can anybody throw some l...

if I don't want to put one up sequence number, is there a function (hash function) in datasatge which can give me a unique value?

I need to generate a random/hash identifier for the incoming key fields, that can be used as a unique identifier on database.

Does Ascential has any function or stage which will create a unique hash values for input?

Thanks in advance.

Hi, I have a couple of files to be loaded to UDB data base. The files to be loaded are like order and order details. Order detail file have the corresponding order key value of the order in each of the order detail record. Now in the data base I will need to load the master order to a order master t...

I have a requirement to encrypt the data and load it to another table. Also I will need to decrypt it for the next stage. Can anybody tell me how to approach this in datastage? I have Server Job and Parallel installed (6.0.1). Do both server and parallel support this? Please give me direction in thi...