DSXchange

I would like to convert date which is in mm/dd/yy to Julian day I had done JulianDayFromDate(StringToDate('06/24/13',"%mm/%dd/%yy")) and i got the result "2419942", which is equivalent to 1913-06-23. But i would want the output to be "2456467", which is equivalent to 20...

Try qualifying the table name with its schema (owner) name. ... No the problem still persists. I gave the schema name.owner name, but still facing the above error. But intrestingly the job did not abort and is still reading in parallel " main_program: This step has 1 dataset: ds0: {op0[2p] (pa...

sridharvis wrote:My sql is working correctly in database prompt and in Datastage, except that in Datastage when i give the partiton table option i get the above error's
Regards
Sridhar V

Can you please help me in resolving the above partition table error.

My sql is working correctly in database prompt and in Datastage, except that in Datastage when i give the partiton table option i get the above error's
Regards
Sridhar V

I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have ... I tried reading the whole table, using Read Method as Table with all the columns defined. Bu...

Hi, I am reading a Oracle source which is range partioned on a key column , i am doing a simple select from the Oracle source using a Oracle EE stage and paassing it to the target dataset. If I perform a normal read without specifying the partition table option, the job reads and loads fine without ...

Hi, First of all i need to thank each and every one of you for creating a good professional forum, as being a premium member i have been receiving so much information about the content and where-abouts of DataStage. DSXchange has been a great knowledge sharing site and hats-off to the people who con...

I have around 50 odd user defined variable in DEV1 project and i need to copy the same to the other project DEV2 available in the same Host system. I would also require the "Parallel options" specified in Administrator of DEV1 be available in DEV2, Is it possible as typing it is a tedious ...

I was referring to your PATH setting in your environment. I have not made any PATH setting. But i have listed down the environmental Variable and its path, additionally i have also listed below the COMPILER, COMPILER options and LINKER options.Hope this helps.. Environmental Variables and Path:- (W...

Probably help to share your 'abort', don't you think? I am sorry , here is the error message Transformer_7: Failed to load the library "V0S7_pxTestJob_Transformer_7.so"; either the directory containing the library file is not on the library search path, or the library was compiled on a sy...

Hi , I am trying to write the DataStage API "DSSetEnvVar" in my C++ Code, I am trying to call the same in my transformer , where the Parameters I pass are (DSProjectName,$SK,lnk4.SK+1). I compile the code it is successful, but when i run the job it is getting aborted. I had created the obj...

Sainath.Srinivasan wrote:What is your PATH ?

Where have you copied the .o file ?

The Library Path is C:\testroutine.o and i had also compiled the .o file and the file is available at C:\testroutine.o.

Try giving the location as C:/testroutine.o. But why do you give the full path as the system itself must be able to locate it. No changes , i tried that as well the error persists, i had spent whole day in writing a simple parallel routine, but all in vain i am not able to proceed further. I am clu...

It doesn't matter where the compiler is, it matters where you run the compile command from. And I'm sure there's an option to create the output elsewhere. Or use "Docume~1" for the directory name. Thanks Craig, both of the solution recommended by you worked , but now i face another compil...

Folder where you object lies (Documents and Settings) has spaces part of its name. Try storing in some place without spaces. Hi Sainath, Is there any other way out, because i find the object file getting created only in the Documents and Settings Path, as that's where the compiler is. I tried the f...