DSXchange

Hi, I need to perform a reference to table where the key includes the effective period. i.e. Key contains of 3 cols - Main Key, Effective From Dt and Effective To Dt. The source brings along the Main Key and event date. I need to obtain the record from the reference which was valid on that point of ...

Can anyone give me an idea of stripping non-ascii chars from a string. For e.g. removing tab chars.

T42, With no disrespect, all I asked for is someone to point out what the mistake with the schema file defn that gives raise to the warning during runtime. i.e. is the data content not a decimal or must some special parameters need to be set to read the specified format etc. This is why I mentioned ...

Hi All, I am trying to read row from a sequential file using column defn from a schema file. The schema file has record ( account_number: decimal[4, 0]; phone_nbr: decimal[1, 0]; ) and the sequential file has 1111,1 2222,2 3333,3 4444,4 Questions: 1.) I am not able to view data unless and otherwise ...

The derivation of writing to the output (link) column is

SpaceStr : TrimStr

Does that answer your question or was it different?

From my experience (which is simple and straight-forward), try using stage variables in the way mentioned below. TrimStr <- Trim(YourLinkVariable) LengthStr <- Len(TrimStr) SpaceStr <- Space(50 - LengthStr) // where 50 is the length of the field. Change if different YourOutputColumn <- SpaceStr : Tr...

Maybe what you need is

awk '{ for (i = 2; i<= NF; i++) { print $1 $i } }' <filename>

Thanks for the information. Is it possible to get hold of any Orchestrate documentation so to gain some insight and understanding of its working. Even though I have good experience with C/C++, it is difficult to follow the flow of the internal files, configurations, working mechanism, methodology et...

Most of the features of copy, modify (and some of filter) stages can be performed using transform stage. Can someone suggest me when do we use the copy or modify stage instead of tranformer. I scanned through the answers and found replies mentioning implicit or explicit transformations. Can someone ...

Can somebody please let me know on what situation does a reject link connected directly to an output seq stage gets fired with some values. The manual says 'for some reason' and can someone clarify what the 'some reasons' are?

Yes. You were correct. The 'Nullable' property was set to 'Yes'. On making it to 'No', the warning disappeared. Having said that, the error appear to be misleading (atleast for people like me). It says When checking operator: When validating export schema: At field "inputcol2": Exporting n...

Yep.

As mentioned the same problem exists when using Sequential input and sequential output with just 10 dummy hardcoded rows - of which none are blank or null.

My job returned the message When checking operator: When validating export schema: At field "inputcol": Exporting nullable field without null handling properties I inserted a modify stage and tried both NullToValue and handle_null functions but still receive the same error. I have made a c...

It uses a config file designed for 4 processors. It was the case from the time when it was running ok. The parallel jobs compile ok. All parallel jobs, however small including a 1 - 1 mapping, fail with this error. Can somebody tell me what this error imply? Also is there a list of error codes that ...

As mentioned, the jobs were running file before and all configurations were setup as required.

Can you please be specific on what to look at and what to verify so it will be easy to trace the lead.