DSXchange

Hi,
I want to encrypt a field (acct number, all numeric of size 16) before insert into an oracle table. Also Have to decrypt for lookup from the table. Please suggest best solution to do this.

Thanks,

Sainath.Srinivasan wrote:Is it on the 'view data' option? Maybe the value is shrinked to fit the size and hence the dot. Did you view via any editor?

Thanks, There is a period for all decimal values in the file like 1234. This period appears in CFF view as well as in the sequential file.

I am trying to read an EBCDIC file using CFF stage. I saw period (.) after every decimal value if I view CFF or write in to a sequential file. Please help?

My job is creating four individual sequential files of the same structure. I want to append data in to the same seq file, instead of using four files. I have tried ExecSh with touch command with a sample job of two seq files and loading into the same seq file. For first time execution target seq fil...

I want to add new parameter to all jobs like owner_stg. Also, I want to modify user defined query with #owner_stg# and table name in the target. Please advise if there any easy way to do this. I have around 500 jobs in a folder.

Thanks,
Moses

Please see the below code,. The job has been aborted. Control not even passes to the first statement. I couldn't understand what is happening. Please suggest. Thanks, $INCLUDE DSINCLUDE DSR_UVCONST.H $INCLUDE DSINCLUDE DSR_COMCONST.H Call DSLogInfo("Start - ") Open 'DS_JOBOBJECTS' To JobFi...

Still not working. I have tried @ID,

Thanks for all of your suggestions. I have fixed minor issues and able compile and run. I an running this with DEBUG statements. Cmd = 'SELECT CATEGORY FROM DS_JOBS WHERE CATEGORY = "HashFilesTest"' Execute Cmd capturing output If DEBUG = "Y" Then Call DSLogInfo("Results of ...

Kim and Ken, Here is some code to read the jobs from a specified folder. Please go through and let me know your suggestions. This code compiled and finished successfully but none of the jobs were compiled. *______________________________________Function Definition ___________________________________...

Our goal is to read jobs under a specified project and category. Right now i have declared an array and assigned jobnames. It would be a problem in the future, if they want to add some more jobs. That is why i want to read the list of jobs from the repository. After reading from the repository, i ha...

Thank you verymuch. I will work on this. Your help greatly appreciated

I am trying to read a bunch of jobs under a specified project and category. Please let me know if there is any way to access Universe to complete this task. Please suggest alternative methods.

Thanks,

San * Setup AdjustmentCode, run it, wait for it to finish, and test for success hJob1 = DSAttachJob("AdjustmentCode", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSLogFatal("Job Attach Failed: AdjustmentCode", "JobControl") Abort End ErrCode = DSSetParam(hJob1, "matrixs...

This statement is wrong: If Status = DSJS.RUNOK or '99' and ResultDate LT CurrentDate Then It should be something like: If ( Status = DSJS.RUNOK or Status = '99' ) and ResultDate LT CurrentDate Then Thanks Ken, I have modified the code, Can you tell how DSLogToController() works. I have used this f...

Simba If you try to compile the current job or a job running then it does unpredictable things. Compiling the job that is running is very difficult to fix. You need to reset status and maybe pull it up in the Designer and recompile. I would clear files after you release the job. Also there is no wa...