DSXchange

yes sorry i misled, its the decryption algorithm which is important. But DSguru, a small doubt, as right now i am having the password ( not encrypted) in the flat file. But passing it to the a job as parameter which is of type Encryption. So the password gets encrypted and the log will contain encry...

Is there a possibility of reading externally (not by datastage) encrypted password stored in a file, to the datastage paramater value

Did u mean that in a job, i need to go job properties there i need to select Encrypted from (string, Encrypted etc...). I get all some stars. And this i need to paste it in the file from where i am taking password.

will it not be some * characters if i do this??


Regards

Hi, We have been storing the password (& other information) required to access a database in a flat file. Every time we needed to access the database, we are getting the information (password and others) from the file and passing on in the sequences. Is there anyway that the password can be encr...

sorry for the trouble. It happens that i used the wrong name DSJ.JPBLASTTIMESTAMP instead of DSJ.JOBLASTTIMESTAMP I copied this from the acrobat reader and pasted in the manager. so never occured to me about the spelling mistake. so gotta be careful from next time :lol: But could u still help me out...

Hello, I am getting the return value as -ve. the corresponding job has been run once for sure. $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle=DSAttachJob(JobName,DSJ.ERRWARN) if JobHandle=0 Then Call DSLogFatal("Invalid Job name"); End Ans=DSGetJobInfo(JobHandle,DSJ.JPBLASTTIMESTAMP) One more t...

Hello, I am getting the return value as -ve. the corresponding job has been run once for sure. $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle=DSAttachJob(JobName,DSJ.ERRWARN) if JobHandle=0 Then Call DSLogFatal("Invalid Job name"); End Ans=DSGetJobInfo(JobHandle,DSJ.JPBLASTTIMESTAMP) Thank you

Hi,

Can anyone tell me in detail, what all factors need to be concerned for "Extract Requirements of Data". We need to start a new project. And right now in phase to discuss about Extract Requirements. We Would like not to miss any point to repent later on

Thank You

To be honest, i dont know how the maintainence issue effects by having surrogate fetched from database and having datastage tool do it? It would be helpful if you could shed light on it. I was being told that the maintainence of these keys is easy on DB2 if the keys are maintained on database. What ...

Hi everyone, I am planning to have surrogate keys in the design fetched from the database. The database is DB2. I know that we can call a shell script from job routine to fetch that. In that script how can i write sql commands for db2 to obtain the stored keys. Does DB2 have any CLI (command line in...

its a new database called netezza. it doesnt support EXCEPT as well. I wrote a correlated subquery (using NOT IN) but the system gets hanged .

are there any other ways to get it.

Hi All,

Its not a question on datastage. Does anyone have any idea to write a SQL query, performing the same operation as MINUS in oracle. because the database which i am using doesnt support MINUS.

Regards

is my question blurry?

I just tried to importing files in other project and most of the jobs werent imported properly. Displaying the error message that the files cant be created and about RF_CONFIG.

is it because of server space??

Regards

Hi all, I keep getting this message when i open a job --------------------------------------------- DataStage Repository Interface (Title) Cannot open excutable job file RT_CONFIG114 ------------------------------------------------------ Nothing happens, cant delete the file or anything. What could ...

Hi all,


Didnt know where to post this. But this is more of a general question.

Does anyone know where i can learn about writing routines (apart from Ascential guides).

Regards