DSXchange

Thank You. We will try the same.

Hi DSGuru

Thanks for the suggestion. Your routine is working fine.

Test Output: TEST #1 ******* Arg1 = \\appbca\data_files\XYZ\Copyfile.csv Test completed. Welcome 0 0 0 896 33206 896 1 -2 0 2013522242 1980505895 3 43019 14178 43019 14178 39072 14178 \\appbca\data_files\XYZ\Copyfile.csv PROD\ticap Result = 896 Please tell me regd the numbers that got generated when...

I am really confused. When there is no data, the routine you suggested gives 896. But if I count the length of the column headings it is coming as 807. I get 807 even if I manually delete the data row keeping the headings alone. I dont know what is that extra which counts when the file is created wi...

Can you post the routine so that we can try to see whats going on and possible try to pin point the culprit. I have a solution to the file name problem. ie before finding the length of the file, as it is a dynamic file, we will copy it to another file and find the length of that file. the second fi...

Can you post the routine so that we can try to see whats going on and possible try to pin point the culprit. Please find the routine below to calculate the lenght of the file. INCLUDE DSINCLUDE JOBCONTROL.H Openseq Arg1 To fp then print 'Welcome' Readseq A from fp then Print 'Welcome' if len(A) > 8...

Hi I need to find the length of a file dynamically. the file name starts with 'blankreport'. evryday a file gets created with the name 'BlankReport concatenated with the system date in it. I need to find the lenght of this dynamic file. I have a routine to get the lenght. I am passing the file name ...

Sorry. I found some duplicate rows in the SEQ file. its because if the look up is found, then it will populate the same rowid created int he previous stage. so even the rowid is getting repeated. Now i changed it like this. I gave a new column ROWID just before loading to the hashed file and made it...

Thats quite strange , if one of the Key columns are unique then no rows should fall out from the Hashed File. Let me try to replicate the issue and see if that is possible or not. What happens if you use a sequential file? Populate it and check out if there are any duplicates. As it can be opened b...

It is not throwing any warning in the log. It's not populating the rows to the hashed file.

S, the ourrownum generated unique values for all the records.

We are going to use the hashed file as look up in the next job.
I created a column and populated @OUTROWNUM to the column and also made the column as key along with other key columns. but still I am not able to populate all the records into the hashed file. few records are getting discarded.

Hi We have a mainframe file which has to be loaded to SQL server. We have so many processes in between before loading it into the database. There are 5 key columns which have duplicate rows in mainframe file. We need to load all the records to a hashed file. But I think as they are key columns, hash...

Thanks for a quick reply. Sorry for not mentioning the version I am using. It is DS7.1r1 where most of the features are not there. Not even the User variable stage u mentioned. The thing is the file name which is getting created when we run the job, is static. So I hardcoded the job name in the para...

I created a routine with the code given below(to remove : and spaces from the Timedate()) FileName = Arg1 Addtag=ereplace(ereplace(ereplace(TimeDate(),':',''),' ','_',1),' ','') NewFileName = FileName:"_":Addtag:".txt" Ans=NewFileName ---------------------------------------------...

my requirement is to copy a file to a share drive for business users.

I need to make the file unique so that next time when i run the job it should not get overwritten.

Do we have any other way of achieving this?
pls throw some light on this.