DSXchange

Hi Guys, I unable to find a way to derive this in the complex flat file . Below is the copy book 01 C-MSG-DTA-PORT-MRK. 10 C-MSG-DTA-PORT-MRK-TBL OCCURS 10 TIMES INDEXED BY PORT-SUB. 15 C-SHP-ORD-CTL-NO PIC X(9). 15 C-PORT-MRK-LN-NO PIC 9(3). 15 C-PORT-MRK-TXT PIC X(40). 05 FILLER PIC X(274). How ca...

Use 'File Pattern' option in sequential file stage to read multiple files.

Hi All,

I am getting the following error Bad dboption list. Failed on Expected "," or "}", got: "@", line 1 when I am running the job from the sequencer.

But same error is not coming when I am running the job.

Thanks in Advance

Hi, I have need clarification to do this scenario, My input is this....... Col1 Col2 Col3 1 A RT 1 A PT I need to have output as this.... Col1 Col2 Col3 Col4 1 A RT PT Can anyone help on this.. Thanks in Advance.......

Hi,

I have scenario in that a lookup stage is used for that I need to use two links one reject and other is stream link.

If the count in the reject link exceeds 100 records the Job should abort

Can anyone help me to do this


Thanks in Advance

If I am changing the Nullable property the job is Aborting

and these are the warnings:

"APT_CombinedOperatorController(1),3: Conversion error calling conversion routine timestamp_from_string data may have been lost"

Hi, I have a problem when Importing the metadata for Datatype BigInt from the table. when importing the key column from the table it writes as BigInt and NotNull. I am using Join stage inorder to get this key When Join fails it should write Nulls.But instead of writing Nulls its writing "0"...

Hi,

I need a clarification that can we use "Shared container in Parallel job" , the shared containers which are built with server jobs.

Do we get any performance related issues?

Thanks in Advance,

Can any one send me Orchestrate Operators guide 7.5 version

Thanks George

This syntax is enough for removing all leading and trailing spaces.

HI ,

Can any one tell me abt the syntax to use in Modify stage for Trim function.

Thanks in Advance

Hi George,

This logic is working in Server job . But when i am trying in the parllel transformer its not working. Why its not working? Can you tell me about that.

Thanks in Advance

Hi, I have a source file which contains duplicates in the data. I used this Derivation If Curr <> Prev Then 'Y' Else 'N' in the Stage variable and rejected the duplicate records to the sequential file which i want do it. I tried the same logic in Parallel job but it's not working. Why does this does...

Hi,

What for we use Datstage Tx. Can anyone tell me the exact usage of that.

If any one have material abt that please send it to me.

Thanks in Advance

Hi,

Can anyone help me out in the usage of @FM,@IM,@TM system variables where we exactly use this.

Thanks