DSXchange

If all you want is to use this hash file as a lookup in other jobs then you don't need a shared container. Just add a hash file stage to those jobs and add the name and columns (Table Definition). The error is referring to the difference between a solid link (a stream) and a dashed link (a reference...

Hi Narasimha,
39202 is an old error dating back to version 3 and 4 - seems quite odd it would pop up now. How about opening multiple Managers or Directors, same error? Are you using username and password or the Omit option?

John

Hi Narasimha, When you open another Designer, are you using Tools | Run Designer from Manager or Director, or just clicking on a DS Designer icon? If you use Run Designer, it uses the same license. Otherwise you are using another license. Try both ways and see if the problem is the same. Just an ide...

Your assumptions are not correct. The right way to substring is:

Link.sourcefield[1,5]

Syntax is [start,length]

John

There is no way directly. I would add one parameter to the job then export the job design to a .dsx file. Then edit the .dsx, duplicating the parameter section and making the necessary changes to match your environment variables. Finally, import the <new> .dsx file.

John

Try using the job parameter name without the #'s.

John

Exactly what Import | Table Definitions | choice are you using?

"Plug-in Meta Data Definitions" lets you pick the database, the schema, the specific table(s). That should allow it to load pretty fast.

John

Environment Variables are not used directly in a derivation. They are assigned to a job parameter and the job parameter is used in the derivation (or in other places). See the excellent FAQ in this forum.

John

DataStage uses the underlying (OS) scheduler, which on Windows is called 'AT'. Windows is enforcing the rule that you have to be an administrator to use AT (DataStage has nothing to do with it).

So, you are right, it won't matter if it is a series of jobs or a sequence.

John

On your (Windows) DataStage server, use the 'ODBC Data Source Administrator'. I think it is found on the Start menu under Administrative Tools. Once in there you should see a listing for Excel Files. Use the Help buttons for more details.

John

This isn't a direct answer to your question, but an observation on the IF THEN ELSE you posted: If IsNull(DSLink15.Wloc_Cd) Then DSLink15.Sav_Strt_tm = '02:00:00.000000' DSLink15.Sav_End_tm = '02:00:00.000000' Else DSLink15.Sav_Strt_tm DSLink15.Sav_End_tm End ConvertToTimeZone(DSLink2.PSG_ACTVT_SDTT...

Sorry I'm not on a Windows server right now, so I can't give you better information. I would try the following: 1. try to get it to work by sending the full path to 'plink' on the call to DSExecute 2. instead of sending 'plink', send 'path' and then look carefully for the path to plink I still would...

Welcome to the forum!

Are you using the same username when testing as when running the job? Each user in Windows has a different %PATH%.

Also, please post an example of your call to DSExecute. That would help us out.

John

Are you using the "Allow stage write cache" option on the hash file? You will see a delay in the job finishing as it writes the file.

John

Here is what the G conversion code does (found in Basic.pdf): G code: Group Extraction Correlative and Conversion Codes C-21 Format G [ skip ] delim #fields The G code extracts one or more values, separated by the specified delimiter, from a field. skip specifies the number of fields to skip; if it ...