DSXchange

Hi Ardw,

Are you saying that the person has a Server routine to extract the log, and this routine can be called in the parralel jobs ?

If so then please let me know how can you use it.

Thanks
Manish

Hi Ardw,

Are you saying that the person has a Server routine to extract the log, and this routine can be called in the parralel jobs ?

If so then please let me know how can you use it.

Thanks
Manish

I think code has to be in C++ if you are using the Parallel routine ..

Syntax is : STAGING_LOAD_DATE:timestamp=timestamp_from_string (column_name)

This will bring it to the format [%yyyy-%mm-%dd hh:nn:ss]

Dont put the job parameter here. assisgn the parameter to "column_name" in seprate stage or use the row_generator or column generator


This should work

Guess if you make NLS as NONE then it will work

Seems its Sorting problem.. Hi all, I am facing a weird issue with the Remove duplicates stage. The job is a straight job input_dataset===>remove_duplicates===>output_dataset It just has two columns which are varchars(these were trimmed before the data was inserted). Now when we try to remove the du...

HI Thanks for the input. My intention for writing JobControl is : Want to run Job every 10 min and evry ten minute it will wait for the file and run the job which depends on the file. To schedule the job to run between 10 am to 5 pm i am using Sequence. The loopin and wait for file, is being handled...

Hi I have a job "manishtest". This is a server job which i am running on Windows NT. I have defined the job parameters : 1 FileWatch ( String type ) 2 JobToRun (Strin Type ) 3 Loop (String Type ) I will be assigning the value through Job Sequence. So want to have these as dynamic. When i a...

Hi All, I created the Parallel routine. Made both the object file (.o) and .so file using MakeFile. When i am compiling the job which uses routine then the compilation is successful.I tried to run the C++ code from the command line and that too is successfull.When i am running the job it is giving t...

HI , This is the Error details. AfterJob (ExecSH): Error when executing command: dsjob -report Abc jbabcr XML > /data/rpt/jbabcr_293.xml /data/scripts/afterjob_rtn_SSP.ksh[63]: dsjob: not found. /usr/java14_64/bin/java org.apache.xalan.xslt.Process -IN /data/rpt/jbabcr_293.xml -XSL /data/scripts/dsj...

Hi All , I am using DS PX . When i looked at the scratch disk size , it is having enough space. As per my understanding PX uses the configuration file which has nodes and scratch disk details. There is a possbility that /tmp space of Unix can get full as there are lot of process running. As per my u...

This happens when the unix resource are over utilised . check the heap size , core dump size , sratch disk size. I guess u must have got the error resource unavailable error as well. U have manipulate the size of Unix file system or need to modify the job or can run the job when Less jobs are runnin...

Hi I am running the PX jobs . I am currently using DB2 API. Here is the error which i am getting. FIRST ERROR :" stgDB2ReadScotiaGlobe,0: Failure during execution of operator logic." SUBSEQUENT ERROR : "stgDB2ReadScotiaGlobe,0: Fatal Error: Fatal: SQLAllocHandle: Failed to allocate en...

Hi, My DataStage Server is in one Unix box (Say Server A) and Database Db2 Server (Say Server B)is on other box. The connection has been defined in the Server A which points to the Db in Server B. Through telnet, from Server A, i am able to connect to the remote database as well i am able to qry the...

HI , The Sequence gets restarted from the point where the job failed, because of the checkpoint option. Suppose the sequence is stopped manually, is it possible that the sequence can start from the point where are job has been stoped. Please let me know the options in this case. FYI ..we are using D...