DSXchange

battaliou

Use 2 jobs. Alternatively create an "After job function". If you dont want to use 2 jobs, you'll have to sort/aggregate your data on the trailer link - not necessary.

battaliou

You're probably better off landing your data into a dataset, and depending on volumes using a lookup or joining the data in a second job. Of course if you insist on using only 1 input stream, you could copy this into 2 sorts based on the join keys and merge your data together. This will have rubbish...

battaliou

if index(StageVar,'-',1) > 0 then '(' :Convert(StageVar,'()','') :')' else StageVar

battaliou

Ha ha ha. Thats excellent.

battaliou

We used x1E and x1F (char 30 and 31) as "end of line" and "field" separators. Just watch out for these characters in password fields etc.

battaliou

Hello Craig, I dont think I got that. Did you say get official vendor support for post version 8 datastage?

battaliou

Welcome to hell. Null handling in parallel jobs should always be done up front. In fact this is one of the foundations of my philosophy when designing a system. Basic rules are: "No nulls", everything converted to varchar or decimal 32,10. Once you've processed your data and you're ready t...

battaliou

If you have a full project backup, you may want to consider abandoning this project and creating a new one. I realise this sounds like a lot of work, but if this problem reappears you probably dont need the stress.

battaliou

Try the index function

If index(TO_XFM_JOB_NM.Field002,"EXT_FILE_DELIMETER",1) > 0 Then jobname Else TO_XFM_JOB_NM.Field002

battaliou

did it give you the same message with truncated dates? If so, try peeking the data too.

battaliou

This is not the normal way to deal with complex flat files. Usually you need to specify their structure (typically using a COBOL copybook import). Once you've extracted this data, you can use a transformer to sub field stuff if you need to.

battaliou

Try changing your target metadata setting to varchar size 10 even though its a date

battaliou

Ok, to save you some hastle here is some code wrongly ascribed as DSGetLogInfo

Code: Select all

event_max_li = DSGetNewestLogId ( DSJ.ME , DSJ.LOGANY) - 1
event_max_le = DSGetLogEntry(DSJ.ME,event_max_li)
call DSLogInfo(event_max_le,event_max_li)

battaliou

Ok, looks like you got a serious problem here. My first instinct is that your "server side tracing" is on. Check it and turn it off using the datastage administrator app. Also check if any of your load jobs are generating warnings, this fills up log space quickly. You will need to tune you...

battaliou

Yes, but whats the point of RCP if you have to define your meta data?

Search found 153 matches