DSXchange

Hi ArndW, the sed/pearl option sounds promising, we would need to run it on the file after it comes out of the CFF stage and has been converted to EBCDIC?

yes, parallel jobs

Hi, we have a requirement to create a CFF files that needs to go up to the MF, and in the file there needs to be an ODO. We are able to read MF files with ODO's on the inputs but now we need to create them on the output. I had read that this is not supported in the CFF stage. Does anyone know if thi...

my friend, you were right, there was an @FM stuck in three and that messed me up, it is now working, thanks so much

Hi, the original encryption is doing just printable chars and the decryption java is being invoked thru the DSExecute command javaExec = JavaCmd1 : " " : EncVal1 call DSExecute ('UNIX', javaExec, Src_DecryptedVal, retcode) and I have verified that the value coming back in Src_DecryptedVal ...

thanks, hoping someone knows how I can get around this error. I am in v9.1

Hi Folks, anyone know how to get the DSSetParam basic function to work to set an encrypted parameter. I have a generic job that I pass the DB name, logon and password to. The password is encrypted using a java routine so that it does not show up in any of the logs of files anywhere, I am then decryp...

thanks for the reply. I think I have it figured out. using an XML export of the jobs I can insert the new paramaters. So far everything is looking good. will be tackling the job Sequences next

Thanks agian

Hi, i have a situation where I need to add 4 job paramaters to all our jobs (over 20,000) and also to the job sequences that run them (over 3,000). I was looking to see if anyone had tried to script a process to add paramaters to both jobs and job sequences and also in the job sequences set them for...

Hey folks, I am trying to get the last mod date and the last mod user from DS_AUDIT for a report. The below SQL is what I am using in a server job using an ODBC stage to connect to localuv. The job abends with the message below. I think its because the fields are multivalued and probally very long i...

The cause of this is a bug, IBM has a patch for 7.5.3, but not 7.5.2 so they are making me one up.

thanks for teh responces. :D

Hi, I am using the file pattern option to read in a bunch of files in the sequential file stage, and i am also taging the file name onto each row with the filenamecolumn and what is happening is the last few rows of the first file that is read is being tagged with the wrong file name. Has anyone see...

Can you tell me how to use a routine to do a runstats on a DB2 mainframe table. We are in v8 on AIX, and we load a table in DB2 using the zloader stage, but now I need to do a runstats before the next DataStage jobs try and pull data from the table we just laoded.

thanks

Hi, what DB stage can I use to connect to a UniData Database, there is no UniData stage in parrellel, is ODBC the option to use, and if so is there any special setup required in the odbc.ini?

thanks

ok, so it sounds like you cannot call a SP in 7.5.2 UNIX like you can Oracle or DB2, for record level processing.

Thanks