DSXchange

Hi All, I'm getting a very weird error when trying to populate an oracle table from a dataset using the load method with truncate. The error is "Fatal Error: Invalid character encountered in table XXX". I've tried a lot of things to get around this problem. One was to use a text file inste...

Hi Guys, Thanks for the tips. They helped me to pip point the issue. Basically, the data files had chr(13) at the end of a few fields. So, I what I did to resolve this problem was to remove this character using the function "trim(field, char(13))" and let the transformer do an implicit con...

A question to the pros.... I've got a parallel job that is reading numbers (figures) from a varchar2 field of an oracle table and converting those figures into decimal(38,2) dataset field using the function stringtodecimal within a transformer. When I check the dataset, the column contains only valu...

Hi there,

I'd like to check with you guys if it's worth taking a course on QS V8 when my company has V7.5. Are they complete different products? or V8 is pretty similar to V7.5?

Any help will be very appreciated.

Thanks
Melquior

Thanks Guys.

Josh, your recommendation worked very well.. all warnings disappered.

Well done!!!

Cheers
MC

Hi All, I am trying to eliminate some warnings generated by the column export stage. This is the message "When binding output interface field "PK" to field "PK": Implicit conversion from source type "string" to result type "string[max=50]": Possible trunc...

Hi Ray, Haven't gone through the rules to confirm but I have tested the web service transformer stage with same configuration in a server job and it works fine. I was mistaken in saying the parallel jobs don't have webservice stages. They do have webservice stages but the parallel version I created ...

Hi All, I've got a requirement to use a webservice as lookup in some parallel jobs. As the web service stage is just available for server jobs I had to create a shared server container to lookup on the web service and deliver the info to my parallel jobs. The problem I am having is that within my pa...

This is what ascential says about this issue: Enhancement request is tracked under 87666. considered not writable from Teradata Enterprise stage NCR Team response is that if the following query returns no rows, then the table is considered not writable from Teradata Enterprise stage point of view: Q...

Cheers Mates

Appreciated the help.

Hi There,

Just would like to check with the gurus online, if it's possible to migrate straigth away the current sequences/jobs we have in the datastage server to enterprise withou needing to transform them into parallel jobs.

We dont need yet the parallelism.

Thanks

Hi there, Another question to the online gurus. I would like know the best practices when setting up a sequence of jobs. I have questions (not to say frustrations) about how to build a robust sequence. Those are the main questions: 1- How to setup a sequence that can restart at the point of failure ...

Hi Guys, I am currently using datastage 7.0. I have already known about the function alternative but am trying to avoid it as writing code in ds basic makes dificult the maintenance. My guess was to use environmet variable with a formula in its value but dont know how to implement it and if it's pos...

Hi there,

I am looking to find a way to automatically generate a string like YYYY-MM (current year and month) within a a job sequence and then pass it through to the jobs.

Have you guys got any idea on how to aproach this?

Thanks

Hi Guys!

Yes, the problem was the parameter type that was different from the job parameter.

Thanks very much for your help.

Have a great Christimas!

Cheers