DSXchange

I need to convert "2014/03/21 5:48:26 PM" to timestamp 24 hour format.
the result should be 2014-03-21 17:48:26 can anyone tell me how to do this.

I compiled successfully using the options you specified. but i am getting this error when i run this job Xfm: Failed to load the library "V0S0_LdFactDemographic_Xfm.o"; either the directory containing the library file is not on the library search path, or the library was compiled on a syst...

i am getting this error ##W IIS-DSEE-TBLD-00000 17:14:39(003) <main_program> Error when checking composite operator: Output from subprocess: ld: 0711-736 ERROR: Input file /opt/IBM/InformationServer/Server/PXEngine/lib/liborchbuildopaix64.so: XCOFF64 object files are not allowed in 32-bit mode. can ...

Is there a function in datastage 8.5 to convert Alphabase26 to Integer.

How to create shared C++ code object and use them in datastage parallel routine . please give me all the steps that i need to create for this.

I am finding it difficult to load a file with double byte characters and load into a db2 table. i am able to load but i am not able to see any data in the DB2 table. when i do a count(*) on the table i am getting the count but the table is empty. source file type is UCS-2 Little Endian when i open i...

How does In-band null differ from a Out-Band Null. What is the use of the null function MakeNull?

MakeNull Change an in-band null
to out of band null
any (column)
string (string)
-

Thanks,
H

There will not be any performance issue if you load the hashed file in DEV and access from TEST. For Datastage only PATH & privileges to access the file matters ( It may be from DEV, TEST or PROD). BUT Better/Standard practice is 1. To make a "/test" directory in server. 2. Then run th...

Now change output<1> to Convert(@FM,"~",output) in DSLoginfo() and show us what gets logged. Ray, After I changed the code as above the output is getting captured. ----------- Seq_Notification_List..JobControl (ChevBeforeAfterSendMail): Output From the unix command --zbil@chevron.com,tbfb...

What do you get when you type this commands at the UNIX prompt? head -1 /chap/lynx/Data/HOU_Dev/outputfiles/notification_test.LYPBIN echo $? It's impossible to diagnose further without knowing that. This is what I am seeing from the unix. $ head -1 /chap/lynx/Data/HOU_Dev/outputfiles/notification_t...

What is returned through SystemReturnCode argument? This is the exit status of the UNIX command. Also, try leaving off the <1> from the output argument when logging the value; the command's first output character may have been a line feed. Instead of output<1> use just output in DSLogInfo() or Conv...

I am using Routine_activity stage to read a flat file in Parallel extender sequence to pass it to DSSendmail. Here is the BeforeAfter DSSendmail code I have: ----------- $INCLUDE DSINCLUDE JOBCONTROL.H * This is just an interlude to the DSSendMail job control function, * to allow it to be called as ...

harishvardhan wrote:Can any one let me know what does this error mean?

Thanks..

Can any one let me know what does this error mean?