DSXchange

Get the Week Starting with Sunday Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) ) , "D-YMD[4,2,2]") The above expression will provide the Week Starting with Sunda...

Week Starting as Sunday and ending as Saturday Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) + 7) , "D-YMD[4,2,2]") The above expression will provide the Previous...

Use this ecpression in Transformer it will replace any special characters with ''.
Let me know .[/quote]

Sorry I forgot to mention
DS 8.0.1
Windows Env
I will post later the solution description from IBM

After a long time IBM sent a patch for the Client which involved for XML Parser .

Thanks :D

Hi As Ray mentioned identify what is the trailing character, most of the time it would be char(10). (Install a freeware Notepad++ which has the ability to display special characters) Use this perl one liner to substitite that trailing character with blank Ex :I have used \000 ( null ) with blank per...

Getting Intermitent Error [b] "APT_PMConnectionRecord::start: cmsg read returned 28, expected 40, Invalid Argument".[/b] The recomended fix from IBM : Resolution was to Fix setConfigFile call to APT_socketWrite and add APT_DUMP_CMSG to get more information (Fix for 112783, 113682 and 11362...

It's not unit - it's uint - unsigned integer. NUMBER(19) does not fit into a regular integer (32 bits) but does fit in a 64-bit structure. That's the 64 of uint64 in the data type. uint64 is a ... Try Using BigInt in the DataStage because it maps to Numeric (19) of the Database. Maximum Field Size:...

Convert the source data from string to decimal...automatically the zero's will be stripped off. If you still want the source data to be string then convert it back from decimal to string..! Have you tried that for yourself? You may just find it is the decimal causing the zeroes... and as Craig has ...

Sairam wrote:Left('00' :DecimalToString(MyVar,"fix_zero,suppress_zero"),2)

Let me know if it works

Please find the correct expression

Left('00' :DecimalToString(MyVar,"fix_zero,suppress_zero"), Len(MyVar))

Left('00' :DecimalToString(MyVar,"fix_zero,suppress_zero"),2)

Let me know if it works

If calling in a independent routine handleJob = DSAttachJob(JobName, DSJ.ERRFATAL) InvocationID=DSGetJobInfo (handleJob, DSJ.JOBINVOCATIONID ) CurrentJob = JobName:".":InvocationID StageName="xxxxx" LinkName="lnk_xxxxx" InfoType=DSJ.LINKROWCOUNT Rec_Cnt = DSGetLinkInfo(...

The '$' character, hexadecimal value 0x24, cannot begin with a name. Line 1, position 1660 System.Xml.XmlException: The '$' character, hexadecimal value 0x24, cannot begin with a name. Line 1, position 1660. at System.Xml.XmlScanner.ScanName() at System.Xml.XmlScanner.ScanMarkup() at System.Xml.XmlT...

Hi I have wriiten a cntrl (server ) job which calls a sequncer and after the Failure or success of the sequencer ,I call DSDEtach JOb Function ,but accidentally it is in the loop and the cntrl job is not stopping . I would greatly appreciate if there are any ways to stop the cntrl (server ) job . An...

Hi

How to stop the Job which is running in the loop .

Thanks