DSXchange

What does Job control do?

How do I convert Blanks to Null? Thx

What exactly is the difference between the above two routines.
An eg would be really helpful.
thx

I want to get rid of sequence, next val calling from dB.
I have just performed a test and seems like I can perform it from these Ds routines as in the subject.
What usage of these functions would help me make these work exactly like dB sequences.
Thanks

We have an architecture with 3 staging areas - data moves from source -> intermediate staging area -> transformed staging area -> data mart. Our extracts are based on a parameter "rundate". What is the best architecture to integrate this with DS job sequencer to automate the process, inste...

Can we read xml files. I think it is xml input stage. If not is there any other way?
Thanks!

Im sure you could read data off database views.
Isnt that right?

Iconv("John^CSmith^X1-234", "MCP") X = "John.Smith.1-234"
The above converts to a "."
How do I change it to a space?

I understand that one of the way to trap and convert a non-Asii chanracted is using a convert function. This would check for identified non-Ascii characters in a list. Im not so happy with this. I wonder if there exists an ASCII function which would convert all non-ascii to a space/something. Pl. an...

I could use the Alnum function and reject unwanted characters coming in.
I want to use a dynamic function that would trim all occurrences of non-alphanum characters in a Trim function / or any.
Thanks!

User has uploaded source data where - ColumnName-RUNTIME Input type - numeric(6,0) Example - 0 I need to load this into a target column whose type is Timestamp Length-23, Scale -3. Target dB- SqlServer format - yyyy-dd-mm hh:mi:ss Thanks! At the sametime if input column type is numeric (10) How to c...

At the sametime if input column type is numeric (10)
How to convert the input to the format - YYYY-DD-MM HH:MM:SS using OConv?
Thanks!

gateleys wrote:

Code: Select all

Oconv(@DATE,"D-YMD[4,2,2]"):' ':Oconv(@TIME,"MTS")

Thanks! that works.

Im trying to convert @DATE::@TIME to timestamp for output to sql server. Sql Server datetime format is yyyy-mm-dd hh:mm:ss So, far I was able to convert to below Oconv(@DATE,"D YMD"):' ':Oconv(@TIME,"MTS") which outputs to - 2007 9 10 09:37:06 Whats the Oconv function to convert ...

I think the best way to get a job param file running for your DS job is by using a getjobparam routine in a before job routine.

Is that the best way? Or can we point to a param file and run the job by scheduling it through director?