DSXchange

Thnx Ray given information DSGetJobInfo(), Ray i am new for the DS i need more can please explain how to use the DSGetJobInfo() it could helpful to me.

Hi ray & Friends, i'm new to DataStage - would appreciate if you can give an example how to use DSGetJobInfo( ) I have one problem in work, please can help to me in solution. i have 3 TABLEs, i am storing data from 1st table to 2nd table. in the job. here i need start_time and End_time of job wh...

Hi Friends
Can explain how to use the "DSGetJobInfo Function " in job.

and where to use this "DSGetJobInfo Function "

Hi swati, better to use external souce from File(pallete). in that one you can give option and use in specific file programme give like this= ls filepath ex: ls jaga/enti/file1 after the can approach in xml input transformer in XML input transformer u can give option In INPUT there is both options 1...

Hi Friends, I have one problem in work, please can help to me in solution. i have 3 TABLEs, i am storing data from 1st table to 2nd table. in the job. here i need start_time and End_time of job which is picking data from TABLE1 and putting data in to TABLE2 These Start_time and End_time i need to ma...

For Server jobs In file Folder U can mention the values sort order------------NONE wild carld-------------filename_*.xml (ex: reddy_*.xml) preserve CRLF-------Yes Fully quelified--------N In XML U can enable the value Where you need repetition value on that column u can enable yes remaining no on co...

Hi friends, this is deesh, actually i am retrieving data from xml files, in that one between start date and End date need one day gap. can you people tell me how to update the one difference. Example:- If the Customer-Contract-Number exists in the LSA database then If the LSA-Policy-Start-Date <> Cu...

Friends can any one seggest the correct method to use isnull in datastage
ISNULL function

Hi, Thanks for your reply... Here primary key tag i mean the main tag that is repeating in the XML file. Here is the example ; we have XML file with various customer data set info. Customer id is the primary key in XML file which is repeating for each customer data set. This value tag is the child t...

Hi,
Friends, this is deesh when i am trying to work on XML INPUT and OUTPUT stages this error is occured can u help to me. This error showing in XML OUTPUT stage


XML_Output_8,0: Info: test1.XML_Input_2: Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure

APT_CombinedOperatorController,0: The runLocally() of the operator failed.


Previously ididnt work on XML Who knows the XML files in Enterprise Edition PX can you provide the suggestion

Previously ididnt work on XML Who knows the XML files in Enterprise Edition PX can you provide the suggestion

XML_Input_0,0: Error occurred in call to ORPHCallActivePluginInitialize().

Previously ididnt work on XML Who knows the XML files in Enterprise Edition PX can you provide the suggestion

Above question related to XML, Previously ididnt work on XML Who knows the XML files in Enterprise Edition PX can you provide the suggestion

[ color=yellow]CopyOfsjLoadPoleobsprs..JobControl (fatal error from mdsRunOraProc): Error when executing command: MSScriptDir/MSRunOraProc.ksh -c TgtDB ProjectName DO_THE_TRUNCATE "'POL_EOB_SPRS_STG'" *** Output from command was: *** SH: MSScriptDir/MSRunOraProc.ksh ///***without autosys i...