DSXchange

Hi,
How can we convert sam smith-jones to Sam Smith-Jones

string shoud have 1st letter capitalized

i know we can do in server job using Oconv(A.NAME,"MCT")

Thanks

Is it possible to write full code i want to know
how we can can do ROW_NUMBER () OVER (), 100000)

My bad i was looking at aborted state and was thinking why its not reset
but when we rerun seq again then it reset the job.
Thanks

Hi,
I am trying to custom email if job failed or is sucessful give me email message, I do get email when job run with success but don't get any email if it aborts. Below is code .

Thanks.


lkup_aa_v.$JobStatus=DSJS.RUNOK or lkup_aa_v.$JobStatus = DSJS.RUNWARN or lkup_aa_v.$JobStatus = DSJS.RUNFAILED

i guess let me give example
seq_build_all has 6 builds extract_1 to extract 6
if extract_1 failed i do see aborted state and i have to manual reset it
where as seq_build_all shows be aborted/runnable state .

Hi, i have a sequence which runs 6 jobs and all jobs in that sequence are set to "Reset if required, then run", so if sequence fails it goes to aborted/runnable state but my 6 jobs goes in aborted state ,i want that 6 jobs to be aborted/runnable state too as i don't want to reset them manu...

Hi, I am trying to do distinct for just one column using remove dups stage dataset-->removedups-->stage when i run it from 1 million dataset rows i just got 11 ouput rows which is right but it took like 30 min any way to increase performance for that or i would say any way to do distinct in dataset ...

When you realistic values well thats what i am doing all are not 1024
i think there is bottleneck when converting string to string max in datastage

Hi, We are processing like 109 m rows from a sequence file to data set so record comes from sequential file then we use import columns stage as data comes in fullrecord and then we output to dataset. While processing 109 m records if we specify datalength in import column performace becomes too slow...

I changed my columns length in copystage i was hoping performance will not decrease as i have like 26 columns length to change ,But now peformance has decresed from 10000 to 2000 rows/second. i also palyed with changing column length by importing the ds file and changing column length in table defin...

i guess i have to do lot of conversation in modify stage like 25 columns and its taking forver and what i am doing is changing column length from string to stringmax[250], Now what can be alternative as i tried changing column length in copystage and it do give me warnings i did get rid of warning i...

so whats work around to get warning off type nowarn in modify specification

Data_Set_In: When checking operator: When binding output schema variable "outRec": When binding output interface field "PROFILE_lennotset" to field "PROFILE_lennotset": Implicit conversion from source type "string" to result type "string[max=250]": P...

when i say string dataset i mean profile column data type is string and i
want to convert it to varchar 250

Hi,
I am trying to convert string dataset to string[max=250] in modify stage
and i am getting error below
PROFILE:string[max=250] =PROFILE

The modify operator has a binding for the non-existent output field