DSXchange

You need to do a search. These have been covered a lot. You cannot use DSJ.ME. You need to use DSAttach() and get a job handle for each job be fore you can get info on it. I went through the routine "KgdGetLastWarning(JobName)" from "http://www.duke-consulting.com/DataStage_Tips_plai...

Hi, My requirement is to write into a log file (.txt file) the status of each job that is run in a sequencer; if Abort then the reson for the same else if Finished OK then the rows loaded into the target or if Finished with warning then the rows loaded into the target and that which were rejected. I...

Hi, If I am right, your input file is a follows File1|data...... File2|data...... .................... .................... FileN|data...... and as your output there would be N files with the appropriate "data". If you are sure about the number and name of output files, then I guess you co...

thanks Ken, for the routines KBATimestampDeltaSeconds and KBATimestampDeltaDays.

Hi, Something I did not mention in the previous post was that the files were fixed width. And I believe that was the cause of the problem too. I changed the both the source files to delimited files and then did a merge (left outer), it worked. The strange thing is that the fixed width format seemed ...

Hi, I think the Iconv (Date to Internal value) conversion for date part should be Iconv(Field(Inlink.ColumnName," ",1,1), "D/MDY") If you want to convert this date to YYYY/MM/DD format then use the OConv on the above result as follows OConv( Internal Value ,"D/YMD[4,2,2]&quo...

I use a merge stage to merge between two file FILE 1 Field1 1 2 FILE 2 Field1 Field3 1 USD 1 SEK My output File should be Field1 Field3 1 USD 1 SEK 2 But my output file now is :( Field1 Field3 1 USD 1 2 Since I need all the records from File1 I use "Left Outer Join" as Join Type. Any ideas...

chulett wrote:Use the SEEK command. There's an example in this post that should help.

thanks once again

Anything happen to your server that you are aware of? Any chance you've run out of space where your project is installed? Here's hoping you've got a recent backup, just in case... :? Thanks Craig. You are right about running out of project space. I am trying to do somehting on that. And yes I have ...

sorry i panicked.

I did a cleanup of the project and everything seems to be fine.

Hi all,

When I open the the designer for my project I do not see any jobs, container and transforms, just the routines.

I also get the error "cannot write to project file"

Any idea what is happening and what i should be doing to get it right?

Sonia

Hi,

I have a routine which appends a character to the End of a File. My question is once i open the file, is there any way to go to the EOF right a way rather that processing each row and waiting for the EOF to reach (done within a loop)

Thanks
Sonia

Hi, you could try replacing the ":" with Nat Key : Char(013) : Char(010). ereplace(Surr Key : ":" , ":", trim(Nat Key) : Char(013) : Char(010)). This would work only if you are sure about the delimitor in the Surr Key. If a output file required is a delimited one then f...

Hi Jim,

You were right it worked. hmm! that is kind of strange.

But thank you very much. :D

sonia

Same error as before :( TEST #1 ******* Arg1 = 2004/09/04 Arg2 = 2005/05/04 Test failed. Program "DSU.EOM": Line 18, Unable to open the operating system file "DSU_BP.O/DSU.ConvertMonth". [ENOENT] No such file or directory Program "DSU.EOM": Line 18, Unable to load file ...