DSXchange

For Alpha:
Convert('<Enter all other Non-Alpha characters> ','',FieldName)

For Non-Alpha :
Convert('<Enter all Alpha Characters>','',FieldName)


Thanks,
Madhu

I think you want pass this information to MS-SQL server.
you can use Convert(' ','T', CurrentTimestamp()) in varchar field,
function to replace space generated from the Datastage and while populating make the target field type as varchar(). This will not affect loading.

From Datastage Administrator you can set up the roles like "Developer", "Operator" etc.

Log into the administartor and click on the project you have to change permissions, then Properties->Permissions.

This can acomplished by using transformer stagevariable -> "Previous value" property and sorting data if required. Logic is to save the count of records processed and increment the count and split the records into 2 different streams. In server job you can do this with out any additional s...

Datastage does not supports '-' in the field names

Try "Right Clicking on Palette->Customize Palette->Then add the Database Stages"

Let us know if you have already tried this option!!

What are stages you are using in this job?

There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs

Looks like data contains Null Value or Low value, Because of which irecords are not getting imported properly. Check the data.

Thanks,
Madhu

See this is because of bad data or date , "esql complaint: ORA-01843: not a valid month "
Do date validation before inserting or correct the source data.

One option is to use Message Handler and "Demote to Informational".

Go to Director->Tools->Message Handler Management to do the same.

Thanks,
Madhu

Your error Message is not complete, Provide more info. Because this message is common.

You can get this by using Date functions and below logic appropriately

Stage1: IF Date1>Date2 Then A Else B
Stage2: IF A then ((GetYear(Date1)-GetYear(Date2))*12+GetMonth(Date1))-GetMonth(Date2) Else ((GetYear(Date2)-GetYear(Date1))*12+GetMonth(Date2))-GetMonth(Date1)

Thanks,
Madhu

Hi,

Can any one tell Maximum number of stage variables Used in Parallel Transformer?

Thanks,
Madhu

Hi,

Please give the steps to be followed while creating XML file using Datastage.

Thanks,
Madhu