DSXchange

Further improvement please help in this, ignor the previous one. I spotted the knot, it was silly mistake. :( EST #1 ******* Arg1 = C:\Orders\ Arg2 = jcOrders.txt Arg3 = 10 Test failed. Program "DSU.SplitFile": Line 17, Improper data type. --------------------------- The code looks like th...

I have a requirement to split a file, into N multiple files. N is dependent on size. Say one day I have 100MB file. I want to split the files of say 10MB(This value will be passed as parameter,will be constant) each. So I will have 10, 10MB files.Tommorrow if I have 60MB file, than I will have 6,10M...

sorry forgot to mention this will work for NT server.

Use this routine, it will give you the file name. *Function GetFileName(FileName,FilePath) Deffun DSRMessage(A1, A2, A3) Calling "*DataStage*DSR_MESSAGE" RoutineName='GetFileName' Call DSExecute("DOS", 'Dir /b ':FilePath:'\':FileName:'*', Output, SystemReturnCode) If Trim(Output)...

Its Oracle error, ORA-00904: string: invalid identifier Cause: You tried to execute an SQL statement that included an invalid column name or the column name is missing. Solution: Import proper metadata into your Oracle stage, directly from the DataBase, Instead of free hand typing. As every body has...

Hi,
I think Link Collector stage in DS, will also solve the purpose.
In which I can have multiple file as input, with same structure and one single output and in properties tab you can specify the collection algorithm.

If I have understood the requirement properly, then taking a case, where there are 1million records coming from source say flat file. Now while loading into a table the load breaks at say 25000, I have set a commit point every 20K records. Now the second time when i restart the job i want to start f...

thanks ray, My requirement is like that.
I still have a problem, either of the way doesnt give desired result when the job status is other than 'finished'.
So thinking of some other way, do let me know if anyone has some other idea's.

hey ray, Thanks, a small correction to your code. It would be "DSGetLinkInfo" NOT "DSLinkRowCount". And in my requirement, I need to get count of different link of my first job in one of the transformer stage of my second job. So if I do Attaching of my first job, to get One coun...

Here is the Solution, Create a routine and pass an argument say,Arg1. ----------------------------------------------------------------------------- Equate RoutineName To "GetLinkCount" Call DSExecute("DOS",Arg1,Output, SystemReturnCode) Count =Output[':',2,1] Ans=Oconv(Count, &qu...

Hey Ray U didnt read my requirement properly. I wanted my second job to read about my first job statistics, from the director log, in one of its Transformer stage and store the information in the Audit Table. And Using after/before job routine in first/second job would mean creating some physical fi...

Thanks Guys,
I got solution to it.

Thanks, But I know i can do it using API or after/before job routine, but i want the value inside my transformer and I dont want to create text file prior to running the job and then read the text file in my transformer stage. I want something that would give me the value, on the fly.

Hi, I have requirement where after completion of First Job, which loads into a table from a flat file, I am starting a Job for Audting. In my Auditing job i want to store the "No of records read","No of records loaded" of my first job. But I dont know how to read Director log and...

hi Guys, My requirement is something like reading a sequential file with header and trailer then loading data into a oracle DB with some business logic in b/w along with a date field which will be read from the header. Then using the loaded records (Not all the colmns) to create an outbound file. Fo...