DSXchange

Why would someone want to circumvent the system publicly? Also, the important part of the message is visible to you.

What happens in the import box when you click on the little box with "..." to the right of the filename field?

(Ignore this post, I just realized I misunderstood the question)

What is your error message?

in that case, did you include the schema name?

UPDATE
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;

What are you actually using as the "Table name" value?

Since you are in a parallel job and your data type is date, you can use the expression if (DaysSinceFromDate(CurrentDate(),In.InputDateField) >(15*30) then 1 else 2 The (15*30) means 30 days times 15 months. If you need to be exactly 15 months back on the same day, you would need to convert your cur...

You are in luck, the $APT_DATE_CENTURY_BREAK_YEAR does exactly what you are looking for.

Although I feel pretty strongly that this type of processing is best done outside of DataStage - a script would do this much more efficiently than a DataStage job - the simplest way to do this would be to use a Server job and in the transform stage call up ExecSH() to create a shell and execute your...

The conversion from VarChar to decimal is an implicit one, so in a modify stage a:

NewDecimal = OldString

is sufficient (OldString is the input string, NewDecimal is the output decimal)

The easiest way to work at this problem is to convert all 3 strings to dates - StringToDate(In.col,"%mm/%dd/%yyyy") and then you can do the ">" and "<" comparisons.

Let us assume the link to your transform is called "In" and you have one string column called "Data". Stage Variables SvOut IF (In.Data[1,3]='XYZ') THEN SvWorkData ELSE '' SvWorkData IF SvOut THEN In.Data ELSE SvWorkData:',':In.Data Constraint SvOut <> '' AND @INROWNUM <> 1 Outpu...

There you are.

Wow - I've never seen a Premium member with just 1 post, you are a first. Welcome to DSXChange.

There are several approaches you can take. First, are there always 4 records to each group or an indeterminate number of records?

Is a line starting with "XYZ" the trigger for a group change?

BI-RMA - if the server job is called from a sequence and not started directly, is the value also 0?