DSXchange

Hi Criag Thanks for your suggestion. But we are having Windows 2003 server and have got DataStage Server 7.5.3 for Windows. This version is new for me, as I have earlier configured with 7.5x2 and then 8. Do you mean to say this version is not correct for Windows? I had a suspicion whether Pentium3 i...

Hi I am getting a strange problem. While trying to run parallel jobs on Windows 2003 server (using Pentium 3) we got the following error [b]"This jobtype is not currently runnable on this platform"[/b]. We have installed datastage server version 7.5.3, and we are able to run server jobs su...

Hi

I have installed .NET Framework 3.5 on Windows 2003. Prior to this I installed DataStage Server. What is the value I should assign to variables like APT Compiler Path, APT Linker Path, APT Compiler Option, etc. Is there any other setting I need to do to get the C++ compiler working?

Thanks
Arnab

There should not be any change in your job design. It's all upto the configuration file specified by the APT_CONFIG_FILE parameter.

Hi DSguru But say I use Windows 2000 or 2003 as my server, will the system function return 1. [quote="DSguru2B"]For a flat file you can use the following. [b]File[/b] is the input argument that will be the fully qualified name of the file to be removed. [code] FUNCTION RemoveFile(File) IF ...

I actually have a server routine with many other things. The requirement is to delete a mere flat file at the end. So I was looking for a Basic command. [quote="us1aslam1us"]Are we talking about hashed file or flat file as commands will differ from one environment to other. Also why don't ...

Can anyone please tell how to delete a file from DataStage server routine. This routine needs to be able to run on UNIX as well as WINDOWS environment.

Hi

If you are reading the data from two tables, you can directly do the join at the source table itself by writing appropriate query

select ..,..,.. from tab1,tab2;

Hi Ray

I had tried this in a job and then posted. It's input format is timestamp only, in the form yyyy-mm-dd hh:mm:ss. Now this format can be set at project level as well as job level.

Thanx

Yes, that will be 0 or 1

Please check the IP address of the DataStage Server and whether the server is running or not. Also check whether the port number is the default one or not.

Look for the Execution Mode provided in the .dsx file. It is 0 for Run and 1 for reset and run.

Also there is a check like the following
If Not(b$CPRestarted) Then GoTo L$V0S3$PREPARED
for the simple run option, which needs to be removed for reset and run.

Can you show me the code for the routine?

See you check the following

1. You should do
Ans=1 not ans=1

2. Check the trigger condition

By the way it is not ans..... It is Ans.

When you develop the routine you have a Type drop-down menu in General Tab. There you need to specify as Transform Function. So when you go to the Code page, at the botton you get Return (Ans). So at the end of your routine, if the Ans is set, that will be returned.

Also check the triggerring.