DSXchange

Hi Pradeep, I can think of a way to do this - though it is not the exact pivoting method. You dint mention what is the delimiter here. From your input read the entire record as one column. say your first record is 1 10 20 30 40. ( i assume delimiter is space) In the transformer stage, you can get th...

Hi Pradeep,
What I understand is that your number of 'computed columns' in input is not limited.
is this correct ?

vnspn wrote: We actually want to abort the job and at the same time capture the invalid value on a output file. Could this be done?

Hi,
I dont think
1) capturing the invalid values in a file and
2) aborting the job
can be done in a single job.

Hi
try doubling up on the ' character.
you can use any convert function in transformer stage.

Eg: Say you want to insert this : Oh 'joy'
you need to insert the value as 'Oh ''joy'''

You can test this with a sample Insert statement.

U did not ask the question. U is one of our members. It's a Burmese name. The second person personal pronoun in English is spelled "you", not "u". Please use a professional standard of English on DSXchange, not least because "proper" English is hard enough for those wh...

Is the Field 'AMOUNT_TYPE_KEY' defined as Not NULL?

Hi Sreeni and Neeraj, I think the problem could be with the logic in the jobs. Ensure that it is not doing an 'Append' to the files. You can try cleaning up of the files in the dir and try running the sequence each time and check the file counts for each run. Are you sure that the problem is not occ...

Hi Santosh, In that case, you can use a routine to decide how many times you want to call the particular DS job. Say if u have 500 records and you want the job to handle 200 at a time, the routine can decide that u have to call the job 3 times and then invoke it in a loop. ( but am assuming here tha...

Hi Santosh, I think u should use the logon clause along with the dsjob command. "DataStage CLI connects to the DataStage server engine on the local system using the user name and password of the user invoking the command. You can specify a different server, user name, or password using the logo...

Hi Santosh
What is your source ?
Is it possible for you to get the count of source records before you call the DS job?

Hi John,
You are asking the same question in multiple different posts.
Please refer my answer
http://dsxchange.com/viewtopic.php?t=12 ... 793250ea70

if you need more details, be more specific.

Hi Vijay,
Got this problem resolved ?

I see that the problem could be with your host address.
It should be your server name and dont add any 'ftp' before the name.

try and let us know.

Hi John,
Can you please be more clear on what are you trying to achieve.?
We can defnitely suggest some approaches that you can implement.

Hi,
Iam not very clear on what is your idea of automatic handling.
You have lot of approaches to do it anyway-

you can use a 'flag' for identifying unprocessed records
or use a change data capture stage to process only changed ones.

Hi,
Have you got this issue resolved ?
Once the job1 finishes, you can use a routine to capture the start timestamp. this routine's return value can be passed onto the next job.

let us know for more details.