DSXchange

HI All I am runnig some job sequnces in production from past 6 months , 2 days back we have made some changes to the jobs in Dev, and jobs and sequences are running fine in Dev. When we are trying to run the same job sequences in QA , the jobs were failing and throwing following errors. Controller p...

One of my team has run this job manually , and file was created on his name , that was causing the issue . I have deleted those files and run thejob through DSADMIN through control M .The job completed sucesfully.

Thanks a lot for all the suggestions.

Hi Ray
All the folders are having correct rights( Write access ) in the file path , still I am facing the issue.

Thanks

The file permissions has not changed and job is runing through DSADMIN in scheduling tool.

Hi All I have a job which extracts data from Oracle and writes to Flat File .We are runnig this from past 1 year on daily basis.from past 2 days job is aborting and throwing error message . Error Message : FF_NewMaster.write_NewMaster: ds_seqopen() - error in 'open()' - Permission denied Can any one...

Hi All
I have one huge file with name price.txt .I need to split this file for every 25000 records.After splitting the out files will be price_timestamp.txt .So I have tried with UNIX split command .this is not meeting my requirement.Can anyone suggest me how to achieve this.

thanks in Adv
hari

Ok. If you are giving the full path, please remove the begining and ending hash signs. The hash sign was if you are passing the path as a job parameter. Just remove the hash signs and you will be fine. So now your command will look like this sort +1 -n /data/datastage/Data/CAST/SOURCE.txt > /data/d...

go to the director log and see what message are you getting for the EXECSH in the after job subroutine. Are you sure you gave the right path. Does all the folders exist. There has to be a spelling mistake. Also, if the job log is not much of a help, then go to the directory where the file to be sor...

Sure. Please specify the columns you want it sorted by. Your input data. Your final output data. Hi Guru As u said in previous reply I have executed the script after subroutine by select ExecSh ..But its not creating file in that particular path. Here I used some dummy job , in the job I am not usi...

if you just want to sort it by second column, then in the after job subroutine, choose execsh and paste the bottom command there sort +1 -n #file# > #sortedFile# file is the full path and file name of the file to be sorted sortedFile is the full path and file name of the sorted file. :wink: Hi I ne...

Hi All I have 4 jobs , my target is sequential file. In First job , I have 16 columns and loading Customer Info into a sequential file . In Second Job , I have 20 columns and loading product data in to the same sequential file. In third job I have 4 columns and aarget is same sequential file. My req...

Thanks CHulett.
I ahve chnaged the format , now the data is going as per the logic to old file and new file.

tahnks
Krish

HI All Is it possible two compare two dates in transformer , which are having the same format. My requirement is If Get_Date < Run Date I need to insert into old file Else new file . The date format is MM/DD/YYYY HH24:MI:SS . When the both date fields having same year this logic is working fine, if ...

HI

I ahve tried with REST , Reset but is not active , I am uanble to compile some jobs in this sequence .getting error message like ' cann't get exclusive access to excutable file job , job may be being monitored.

Thanks

Reset but is not active , I am uanble to compile some jobs in this sequence .getting error message like ' cann't get exclusive access to excutable file job , job may be being monitored.