DSXchange

Made it fully Qualified XSD file & parsed ok in XML Importer, as: <?xml version="1.0" encoding="utf-8"?> <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> But still validatio...

Ernie, could you elaborate on how could i make fully Qualified XSD. Do I need to add tag into XSD file as well as : <xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Extract.xsd"> Currently I have below mentioned qualifiers in my XSD File. <?xm...

It's for multiple valid XML data files against a single XSD. Following are the list of settings done in Server & as well as in parallel. In parallel I am reading the xml with external source activity & in Server I am using Folder stage. XML Input Settings: General settings: 1. Validate input...

There are no Fatal/errors/Warnings in the Job, Since I'm running the Job with Valid XML data file. Upon validation against XSD,Either It should reject the Data file or it should parse and load the data,but in my case both are happening.Its getting rejected as well as data is getting loaded. ---Thanks

Hello all, I was wondering why Parallel Extender is not able to validate XML Hierarchical file against the XSD when the same is happening in Server Edition. In parallel its actaully rejecting the XML Data file & and also it's populating the records into database as expected. I know ,It's already...

Hello, I have created a transform routine as shown below. It actually restructures the incoming data and creates the file & writes the data in append mode. Routines is behaving as I am exepcting but the issue with this I have to touch the files first (I have to get the zero byte first file creat...

Hello all, I need to get files through SFTP server mounting on Windows to Unix Box. Here it's not the passwordless SFTP and we have to use required authentications to pull the files from the Windows. Till now what i know is UNIX based systems (Linux and OSX) come with SSH preinstalled and for window...

My Bad,
you can go with Sincefunctions Or with
DateData1.TmStpFld [1,14](Right(DateData1.TmStpFld,5)[1,2])-05):':':Right(DSLink16.Out,2)

DateData1.TmStpFld[1,14]:(Right(DateData1.TmStpFld,5)-05:00)

Read both the table Data separately with the new unique numbers associated for each and then try to join on that particular unique number. Once joining both the tables ,in new transformer stage try to add your constraint If (Trim(OKCUA4='') and SR_TR_OCUSMA.OKCUA3 = SAP_DESC) Then SAP_VALUE Else if ...

Try reading it as varchar value from the sequential file.

In first select statement I can see 7 columns and second select statement you have mentioned only two columns, Then How could you union these two statements ?
What you want to do ? can you elaborate your requirement more ?

You won't get Reference table column's list in Input column property as Lookup will give you only master table column list. you can have transformer/filter stage after doing lookup where you can mention that paticular "between"constraint then i think you will be in position to catch reject...

We too upgraded our DS server from 7.5.1 to 7.5.3, we done the normal compile and promoted code to newer version and didn't find any issues.
Any way, why to worry do the force compile.

Not Compulsory,even with Normal compile will do.