DSXchange

Hi, I am using a control job that sets file parameters and file locations, archives files, and calls four different processes in succession. I use this piece of code in the control job which will abort the whole process if files are not present and inturn send me an email let me know the status. if ...

Hi, I am trying to create a routine that will scrub carriage returns and line feeds from the end of a field in the transform stage while the job is processing. This happens on our customer data when individuals cut and paste their address and leave a trailing CR/LF. My file layout is fixed and when ...

I have just install DataStage 7x on a new server(1) and exported jobs from another server(2). Both servers have license version of WinZip. On server(2) I have job control statements using "NT" DOS commands like 'wzunzip' that unzip the file and return a message of 'WINZIP(R) command line s...

Tried that. I tried \\server\filefolder\report\, \\server\filefolder\report, D:\filefolder\report\, D:\filefolder\report

Steve

Hi, I have looked through a lot of posts but still need help. I'm using a After-job Subroutine of DSJobReport. My input values are: 1 ; D:\FileFolder\Report\ It gives me the error of: Failed to open directory D:\FileFolder\Report\ Do I need to put the path in quotes or something? What is the proper ...

Thanks Ray, I let you know how it goes.

Steve

Hi, When we installed DataStage we put it on the C:\ drive. We have run out of space, but have plenty on the D:\ drive. How can I move all the info (logs, templates, project info, etc.) to the D:\ drive without screwing up any of the current jobs and make sure any new jobs are pushed to the D:\ driv...

Hi,

Has anybody schedule a single job to run multiple times during the day? When I go to the director I only see where you can schedule a job to run once, unlike in a DTS package where you can select every hour. Any help would be great.

Thanks in advance.

Steve

Thanks,

I had the project preset at 50 warnings.

Steve

Hi all, I have job that updates or inserts records into a table which is part of scheduled sequence. I expect there to be a lot of warning for failure to update records (that's normal for this job, there should not be a lot of updates). My problem is that this part of the sequence aborts because it ...

We are running jobs which bulk insert several tables ranging from 5 million to 20 million records each day. For narrow tables we average a load rate of about 750 records/sec. The row buffers are set to 512Kb, In process. The commit size is 10000. The source data is remote to the target server across...

ram1899,

Thanks, it worked perfectly!!

Steve

Hi All, I am using a control job with a date parameter to capture a date and apply that date to an output name of a file I am creating. Using this coding, I can set the parameter to the current date or the date I run the job. The job is actually processing the previous days activities and I would li...

Thanks for all your suggestions. I knew running all nine control jobs was not the problem because prior to this week they have been running successfully for months. The past two weeks the server has been tweaked and a lot of cooks in the kitchen thing has happened. We rebooted the server and the nin...

Help! I am running 9 control jobs which call 9 sequence jobs which executes 9 load jobs and writes info to 9 audit & link tables. Each control job is based on a location and each are separate jobs, tables, hash files,etc. I can run each location separately, but when I start a sequence job that c...