DSXchange

Also disable write caching for the hashed file stage that writes to the hash file.

You will have to install National Language Support (NLS) with your DataStage server. When you do this, you will see an NLS tab next to the General Tab in your data source and target stages. :arrow: In the source stage, specify UTF-8 (Unicode). :arrow: In the target stage, specify MS 1256 (Arabic). T...

Sybase PowerDesigner 10 and upwards supports Red Brick.

Locate the DLL's of the plug-ins, and re-register them in Manager. Use: Tools --> Register Plug-In... then register the DLLs before trying to open the jobs in Designer. I'm not sure if there's a way to "migrate" all plug-ins automatically.[/code]

Just check if it needs a leading zero:

Thanks! I had to make two corrections to Ray's code: INSERT INTO DICT DimDateHash(@ID, F1, LOC, FORMAT) VALUES ('DateID', 'D', 1, '19L'); It is, of course, the actual hash file name (DimDateHash) that is used and not the routine's file handle (DimDate). LOC is a number and not a string so it's 1 and...

Mainframe accessibility in DataStage is not included in the software by default. As far as pricing is concerned, you'll need to take the pricing of the relevant plug-in(s) into account.

Some additional info:

When I import the hash file's def, I get one field called AT.ID, Varchar length 10. It should be one field, either Timestamp len 19 or Varchar len 19.

... or the Re-Build Indexes option from the DS.TOOLS menu on the server. Please allow me to ask a question that will surely make obvious my level 1 status. How do I get to this DS.TOOLS menu? Are you selecting "DS Routine" from the expression editor's operand menu? Yes, and it wasn't ther...

I have a time dimension that simply needs sequential date values in a YYYY-MM-DD format. How can I use a DataStage job to populate a time dimension? (I am not interested in PL/SQL scripts, etc. I know how to do it with those.) There must be no datasource. The job must generate the values and insert ...

ray.wurlod wrote:Here it is!

My point, exactly. If I can see it in Manager, why not in Designer?

My code is case-sensitive. It's called Timestamp in Manager, and Timestamp in my code. No joy. I tried compiling it with the red error signals, but it doesn't compile. The functions I can see in Manager's Routines\Examples\Functions: ConvertMonth ConvertQuarter ConvertTag ConvertWeek ConvertYear Qua...

I solved it by salvaging code from Timestamp in Manager. To insert the new value: Oconv(Iconv(MatchField(Latest_date.DateID,"0X' '2N':'2N':'2N",1) ,"D-YMD[4,2,2]") + 1,"D-YMD[4,2,2]"):" 00:00:00" To insert an initial value: "1996-07-04 00:00:00" I ST...

I simplified the insertion of the initial value by just using a timestamp string from the start. To insert the new value: Timestamp((Timestamp(Latest_date.DateID, "DATE") + 1), "TIMESTAMP") To insert an initial value: "1996-07-04 00:00:00" I still can't see the Timestam...

I've now been trying to use the Timestamp DS Routine to accomplish my goal: To insert the new value: Timestamp((Timestamp(Latest_date.DateID, "DATE") + 1), "TIMESTAMP") To insert an initial value: Timestamp(Iconv("4 JUL 1996", "D"), "TIMESTAMP") For ...