DSXchange

I did try this and both commands give the same number !


SH -c "dsjob -ljobs Project1 | wc -l"


SH -c "dsjob -ljobs Project1 | cut -d'.' -f1 | uniq | wc -l "


Thanks for trying!

Hi,
I need to find the total number of jobs in a project, I can use the

SH -c "dsjob -ljobs <Project> | wc -l"

But the issue is it also counts the instance of a job and bump the number way up, is there a way I can count Just the jobs and not instances?

Thanks,

Hi,
If lets say there are 5 jobs that are required to be run but in a specific sequence, can we control that too, I am looking in to the UtilityRunJob, but trying to understand the design to in corporate the job dependencies.

Thanks !

Hi, We have a scenario where we need to kick off a job if the job name is populated in a table, did any one had a smiliar situation, basically a table is populated (clear and load) every day with job names, if the DS job name is present in the table that needs to be kicked off, we are using ControlM...

Hi, I am getting the same error, even though the parameters are all correct ! Error executing View Data command: ##E TCOS 000005 10:52:03(000) <main_program> Invalid identifier: $ ##E TCOS 000005 10:52:03(000) <main_program> Invalid identifier: $ ##E TCOS 000048 10:52:03(001) <main_program> Paramete...

Hi, I am loading into an Oracle table and out of 200 rows , 25 get rejected with SQL code 1403 so I changed the upsert method from "Insert then Update" to "Update then Insert", now all the 200 are rejected with ORA-01458: invalid length inside variable character string ! Is there...

Finally i think i have figured out the issue, the char column comming in is not being identified as Null, I used the following IsNull(Trim(Src.Col)) and I made a simple job that checks and writes the nulls and not nulls based on Src.Col to 2 different streams and all the rows go down the NOT NULLS p...

Hi,
It still rejects with the 1400 code, looking closer it is the fields of char type, I wrote the rejects from the oracle table to a flat file and the columns with char type do not have spaces and are null.

Thanks,

hi,
I didnot get your else part and also there is a extra ')' at the end.

I am trying this

If IsNull(Src.Col) then '' else (Convert(char(000)," ",Src.Col))

Will let you know.

Hi, I am trying to load an oracle table and have issues loading null values into NON-Nullable fields. I did use in the transformer preceding the oracle stage 1) If IsNull(Src.Col) then " " else Src.col (Also tried with If IsNull(Src.Col) then ' ' else Src.col) 2) Set APT_ORACLE_PRESERVE_BL...

Hi,
Now I also have to convert a hex value to binary.

56e2 =0101 0110 ...

Looking to check if we have afunction for that.

Thanks,

Hi ,
I used a basic transformer and Oconv(ToOconv.Src, "MB") function.

Hi Ray, Sorry for the confusion, yes I need the binary output. I designed it with the basic transformer and got the output, how ever is there away to keep the leading zeros with any options: 56=11100 (Can we get 00011100) Secondly, do we have any options we can mention in the function so that it tak...

Hi, I need to convert varchar to hex value. There are 2 parts to it, first convert from varchar to hex but take only 2 at a time from the below source column: SrcCol=56243312.... Required Output value (if we just consider the first 2 i.e. 56) outputCol=00011100 Did any one come across sucha situatio...

Hi Kumar,
I am using a composite key (Col01) , thanks for the idea, also do I need to add a dummy row at the end so that the last record is captured?

Thanks again.