DSXchange

Sorry for not mentioning the details. I tried to pass 'Date+1' as 'Sainath' suggested by doing this: DateOne : OCONV(InternaltDate+1, 'D-YMD[4,2,2]') as stage variable Calender Week : TAG.TO.WEEK(DateOne) The problem always in the last week of year, which depends on the number of days at the lase we...

Sainath, It's not working.

ArndW, I've tried tried your routine and it gives the following output: InternalDate, JulianDate , FirstDayOfYear , DayName , Date 14637, 27 , 3 , Sunday , 2008-01-27 14647, 37 , 3 , Wednesday , 2008-02-06 I don't know why the 'FirstDayOfYear' is always '3' for these records? Ray, I'm not pretty han...

ArndW, I tried to use WeekdayFromDate() in a transformer but derivation is getting red.
What's I'm trying to do is getting the week of year by using WEEK.TAG but with week starts at Sunday.

I don't know how to use WeekdayFromDate() in the previous context.

Thanks for your reply.

Dears,

I was wondering about how to customize the 'WEEK.TAG' and 'ConvertWeek' function to retrieve a week which starts with Sunday instead of Monday.

Regards.

chulett wrote:Learn to love them as they are your best friend in that world.

I'll do my best to love them. I went for the hashed file solution instead of the db direct lookup and it worked as I mentioned before.

Craig, Thanks for the valuable tip up there.

Regards.

why is the lookup failing? That's exactly what I'm asking. The expected result should be: ID Name Country_Name 1 XxX Egypt 2 YyY US What I didn't mention that the key column of lookup is 'ID' with data type Integer and 'Name' and 'Country_Name' are non-key values and their data type is VarChar(50),...

Dears, I'm a new practitioner to server jobs with parallel background. I'm using the transformer stage to perform a lookup operation. There're two inputs (DB2 stages) for transformer stage and one output (DB2 stage also). Although there's a match between inputs on the key column, the output column f...

You might miss dashes, try this:

StringToDate(incolumn,'%yyyy-%mm-%dd')

You might miss dashes, try this:

StringToDate(incolumn,'%yyyy-%mm-%dd')

Because there isn't before-sql part in stage OCI of parallel job I didn't work with OCI stage, but if there's a 'user-defined upsert' it can fix the problem by putting the 'truncate' statement instead if the insert statement and the 'insert' statement instead of the update one at the stage. But you...

I have the file, but I cannot see any mention in the file for expiry dates. what to look for?

OK I managed to get the license information from the DataStage Web Console: DataStage and QualityStage Server: 4 CPUs DataStage and QualityStage Designer: 5 concurrent connections DataStage and QualityStage Director: unlimited concurrent connections DataStage and QualityStage Administrator: unlimite...

Same error

-bash-3.1$ bin/dssh
An error has occurred during DataStage initialization
Please contact the system administrator
Error code: 3 22
-bash-3.1$

I installed with a development license I got from IBM through our partnership, I'm not sure if it's expired now or not. But even though who to know if the license has expired if I can't even get the license tool (dslictool) to run?