DSXchange

Hi , I am trying to create a Parallel routine for the first time, I have created server routines before , The problem is when I Select "NEW ROUTINE" I get to see the "GENERAL", "CREATOR" and "ARGUMENTS" tabs but not the "CODE" tab ?, What could be wr...

Thanks ArndW !

Works just great !

Hi , Is there a function in parallel similar to DIGITS() in server. I have a string like Ex: bnfcv56567uyuh In a server job DIGITS(bnfcv56567uyuh) gives "56567" , I need the same functionality in a parallel job. How can I acheive it ? The number in the string can be of any length, so I can...

Is there a parallel stage which supports both input and output links with the same metadata?

Like SEQUENTIAL FILE in SERVER ?

Hi Ray,

Where can I set the NLS_LANG variable, Can i do it on the job level or does it have to be on the project level, Where can I see and change the set parameter?

Thanks

Hey everyone, I am loading a Oracle table (UPSERT) and I get this warning: main_program: An NLS character map <ASCL_ASCII> is specified, but NLS_LANG is not set; the NLS character map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG. What does it mean ? T...

thanks for the clarification guys !

THANKS GUYS!!

DSGURU's Derivation worked like a charm !

Marking as resolved !

But my input data is "20010101", shouldnt I mention the mask for the Input data ?

Same ERROR when I use "%yyyy%mm%dd" :( APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%yyyy%mm%dd" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeS...

ok, I am using StringToTimestamp(INPUTCOL,"yyyymmdd") and my input is 20070101 This is my FATAL ERROR log APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "yyyymmdd" for conversion "timestamp=timestamp_from_string[%yyyy...

How do I use StringToTimestamp(%string% ,[%"%yyyy-%mm-%dd %hh:%nn:%ss"%]) Function in the transformer ? The part in the RED is supposed to the format of the input string or the output string. I suppose its the INPUT format, So if my format is "20010101" am i supposed to use "...

It dose not work, Can I convert Char to dat and Date to timestamp as you said in a single modify stage ?

(NEWCOL:timestamp)= timestamp_from_string(OUTCOL,%yyyy%mm%dd) is this correct ?

Hi everyone, I have a job where I get the input as char and I have the data in this format "19500101". I used the modify stage to convert this column to timestamp, I used the specification as "NEWCOL:timestamp = timestamp_from_string (INPUTCOL)" . I get the output as "NULL&q...