DSXchange

Yes Ernie, as you said the issue is with the data in the columns when used a sequential file. Now I used the tables directly as source and it works fine.

Thanks again for all the information:)

I will try using table as input. thank you very much for the input.

Thank you Ernie.
I did not see the record flow in the job from XML output stage but looks like XML files are created but I see that each record has created a file.As there are 20 records 20 files are created.

Any setting needs to be changed?

Trying to compose XML file with records. I use XML output stage and imported the definition as well. To include the parent tags, I just added them in the transformer and other columns are imported.Also gave / in the declaration for the XML field name. I do not see any error or warning but no XML fil...

But in my situation I cannot use only external source as after parsing this XML. I need to read the CLOB field directly from a table. Now after increasing the APT_MAX_DELIMITED_SIZE and using the sequential file as input I got rid of all the warnings and I can view the XML also in Sequential file bu...

I used /text() in the description and it worked fine when used external source as input giving the file location but when I replaced the external source stage with original file using sequential file changing the property from file path to XML file in XML input stage... the records are not getting p...

I am parsing an XML document using XML input stage but only open and close tags can be parsed into records and single tags appear as tags for the null records.how do I see null in place of <Faxno/>.....

Please let me know if any changes need to be applied

We are on 8.5 but we do not use ISD for any purpose.

Thank you!

Thank you very much for the information. I will work on implementing the better alternative . Will ask the DBA if the trigger can create a file on DS server and then once DSjob sees the file it will trigger the job. Please let me know if I understood it properly. @Chulett we do not have ISD in our e...

Hello everyone,

My requirement is the DS job needs to be triggered when ever a record is inserted in a table. Once the job is triggered it will process transformation for that inserted records.

Please suggest how to trigger the job when ever a new record in inserted in a table.

Thank you

Hello everyone,

I have a column by name table_name which has all the table names in it,I need to send those table names as parameter to a select query in an ODBC stage.

Please let me know how can I pass that column records to the table name in that query

Thank you!

Actually the server has 2 DB's on it and the DSN was created only for 1 DB now we submitted the name of other DB as well so new DSN has been created for it.

Now it works fine,

Thank you all very much:)

please let me know where do I see this? In the administrator client?

Hello, We are connecting to SQL server DB for the first time from ODBC connector stage.The Admin says he established the connection to connect to SQL server as we provided him the Server's IP address, port number and DB name. I can connect to the same DB from an external client but when connecting f...

Thank you all very much!

Will work on it and get back if I miss anything