DSXchange

servjdev.pdf has more details on the "D" function.

Hope This Helps

Hi Prakash,

I am getting the below error

APT_SAS_Export,0: subprocess failed with exit code 2,APT_SAS_ExportDriver in APT_SAS_Export


Can you please tell me the solution ?
Do i need to change anything in the dsenv file ?

your help will be appreciated .

Does the new user have permission to schedule jobs ?? Entries should be available in cron.allow and at.allow

you can do something like this.. Wait for File (looks out for .csv file) File Found ? Trigger job to process that file Rename the file as .processed File Not found ? Sleep for designated time (say 1 hour) or Exit the sequence The strategy to be used depends on the frequency with which you want to lo...

This should work

search on KeyMgmtGetNextValue will give you all the details.

Hi, It was a bug in 7.5.1A, there was a patch available though. Looks like they havent fixed it in DS 8.

For the date conversion, try to use Oracle to_date() function

Thanks for the reply...
In the PATH variable it is pointing first to VC++ 2005 ... any other vairable that need to be changed or any Project specific variable to modified. Please clarify.

Thanks Much.

Even i am using the VC++ 2005 on win XP but there is problem in compiling Transformer stage. All the other jobs with transformer works well. I tried setting the C:\Program Files\MKS Toolkit\bin\ncev.cmd file manually as it does not contain entry for the vc++ 2005 version 8 compiler. But no luck. Can...

Thanks bashbal.

This confirmation certainely helps.

We are now moving to 7.5.1 and I know that $PROJDEF would definetly work there

Thank you all for your support. I will mark this topic as Resolved.

If your input data is relatively less, use sparse lookup instead

char(13) : char(10) will give you desired line break

I think you can call the pl/sql script using call function

Thanks Josh & Craig $PROJDEF does not work. I don't know why. People tell me that it works in 7.0.1 and not in 7.0 When I give $PROJDEF as default value, the string value "$PROJDEF" is taken as the value for the parameter (which is not what I want). For eg: Default value for SOURCE_DB,...

The cxx.ccg is in the folder
c:\Progra~1\MKSToo~1\etc\nutccg even i am facing the same problem. Tried copying the files from nutccg directory to etc, but no luck. Also the PATH env variable is set correctly. I am using MS VS 2005.

Any clue. Please advice.

Regards,
Hemant_K (N)