DSXchange

Design: -Oracle Enterprise stage is retreiveing this decimal38 number:18446744073709551616. It is deliberately greater than the largest unsigned BigInt. -This number is sent to Modify stage. An explicit conversion to BigInt is performed there (uint64_from_decimal) -At the end this is sent to a Seque...

The right format is "%20llu". Thanks to people at comp.lang.c

Wrote a simple "hello world" in c. It behaves the same. So now I know this s a c language issue. Posted a question in comp.lang.c newsgroup.

I'm trying to write an unsigned BigInt column to a sequential file (fixed width) The column comes out from a Modify stage where it is converted from decimal(38,0) (I know, possible range limitation) to uint64 using "uint64_from_decimal". I have also tried implicit conversion inside a trans...

Been trying the whole day. (things like %llu, %Lu, %20u etc...) No luck. It always ends up left justified. And it doesn't make any difference if I don't specify the Out_format at all.

Thanks Ray, It took me some time to get this "lookup_string_from_int16()" working. Never used it before (neither this, nor the Modify stage). This solution actually requires me to extract the information about the month from date and then perform a replacement of the month (using the looku...

nick.bond says: ...but you need root to do it with unix ... ... I have just tried clearsockets for the first time. It doesn't work: 1) I do need to be root. While not root I get: Permission denied. Root/super-user privileges are required. clearsockets aborted. 2) While root it doesn't complain, but ...

I need to write a date to a sequential file with a three letter abbreviation for month. My locale is set to Croatian, but I still get the English abbreviation. The help says: The locales define the local formats for dates, times, sorting order, and so on that the project can use (for Parallel jobs, ...

A timestamp format string must have both a date portion and a time portion. Yours just has a date portion. [/quote]

Didn't know that. Resolved.

A timestamp format string must have both a date portion and a time portion. Yours just has a date portion. [/quote]

Didn't know that. Resolved.

Sequential_File_7: Error when checking operator: At field "dat": When validating import/export function: "timestamp_format" property value (%dd%mm%yyyy) is not a valid format. The column that this date comes from is timestamp SQL type. If I leave the default format (%yyyy-%mm-%d...

Thanks. I'll try that.

Hey Ralleo, I'm not quite sure I understand. So let me go through this step by step: 1) Initially both DataStage and JobMonApp are up and running. 2) Then JobMonApp stops. DataStage is still up. 3) Then I stop DataStage. 4) Then I issue uv -admin -clearsockets command. 5) Then I start DataStage. 6) ...

gbusson wrote: Check there is no other application running on the ports taken by the JobMonApp So I installed lsof because one can supply it with a port number as input parameter to see what's using the port. Then I wrote a script to capture this into a log file every second. It is pasted below in c...

It somehow started working again...