DSXchange

So, UNC path - this file is actually on a remote server. UNIX or Windows? Is the filename a job parameter or coded in the job? No clue what a 13 is but I'd double-check permissions. ... We are in Windows.And the file is in DS server only. Before this job activity we have excute command activity tha...

So, UNC path - this file is actually on a remote server. UNIX or Windows? Is the filename a job parameter or coded in the job? No clue what a 13 is but I'd double-check permissions. ... We are in Windows.And the file is in DS server only. Before this job activity we have excute command activity tha...

So, UNC path - this file is actually on a remote server. UNIX or Windows? Is the filename a job parameter or coded in the job? No clue what a 13 is but I'd double-check permissions. ... We are in Windows.And the file is in DS server only. Before this job activity we have excute command activity tha...

Windows is not case sEnsiTive. Can you post the full unedited error messages, please, from the scheduled run? ... Get_Schools..School_abc_out: DSD.SEQOpen Failed to open P_abc.txt in directory \\mtdapp09\P311\InputFiles\Schools STATUS = 13 But actual file p_abc.txt. when I ran it out side the sched...

HI All I have a Job seqence that is scheduled to run every day. When I ran the whole seq with my credentials it is working fine, when we call it from the scheduler it is failing. Log tells me that unable to open the .txt file. when I recompile ran the job locally it is working fine. I need to notify...

Hi, I am having excute command activity on my sequencer, it calls windows batch file which will get the input data from ftps site. Problem is when ever we ran the job sequencer it not processing Exec command stage, it is stoping there and job is in running state. if we ran the script out side the da...

Hi, I came up with another issue, I have a sequencer that has Execute command activity as the first step. Here we are calling .bat file that fires ftps script and gets the Input file to datastage stage server. After this step done sucessfully I have other process to follow. My problem is when I kick...

thanks for the info. I walked through the trans4 stage and there is no arithmatic division in any of the column. My design is like this Seq file-> Agg -> Hash file ->transformer. Hash file input is 10K records but output is only 33 records(which is the input for Transformer). I am not clear where t...

Sainath.Srinivasan wrote:That is mutually exclusive and completely unrelated. ...

Excuse me! I did not get you

VKR

Hi,
How can we delete .txt file that was present in the datastage server
we read that file every day and do the process, after all my process fininsh I have remove the file. this is my requirement.

Can we do this from datastage.

Thanks
VKR

The "stop" request is just that; the job needs to be checking for this flag to be set. Since it is executing within the before-job portion it won't get this signal. You will need to kill the process running the .bat file from outside of DataStage. Hi, We ran the .bat script out side the d...

Hi All, I tried to run before job subroutine ExecDos that kicks of .bat file which will do ftps process.(we can not use ftp stage) I ran the datastage job, it is started but not finished,when I checked the Log it shows me like only 3 entries. The job is still running since last two hours. when i try...

Hi, I have One Question Regarding DataStage Licence Restrictions. At my work Place we have IBM Information Server 8.0\ Classic. My question is how does this Licencing this works, Is this Limited to One Varient ? Like Limeted to server or Parallel ? I am asking you because, here they said me like par...

Friends, I have an Issue at my work. The Issue is, I have a big text file which is Pipe delimer on it. I am trying to read that file in colunms 1.NO(decimal) 9 and 2.Remdata(varchar) 9999999 and I am writing in Hash file for lookup purpose with yesterdays file. Here i am getting problem, Lookup is n...

I am not sure about MKS Tool Kit. Can you are any one suggest me how would i tell data stage if my input file does have less than 1 milion records. In the IBM Information server 8x, server edition.. windows platform.. Please let me know VKR First, please do a better job with your choice of subjects,...