DSXchange

The Oracle OCI9 stage automatically puts a TO_DATE(yourcolumn, 'YYYY-MM-DD HH24:MI:SS') statement on the SQL for that column when using auto-generated SQL on DATE datatype columns. All you have to do is make sure your date is in that form, if it is not, there are posted functions on this forum that ...

I'm looking for it, where is it? A new post means a NEW POST, not a reply on an existing message thread.

If you want to exchange or replace substrings yourstring=CHANGE(yourstring, "XYZ", "ABC") will change all "XYZ" substrings to "ABC". If you want to map an array to other values: CONVERT "XYZ" TO "ABC" IN yourstring will change all "X" to "A", all "Y" t...

If you want the character location of the first occurence:

If you've created them using the 'pathed' option, then yes, backing up (in some form) the entire contents of their folder is sufficient. But How can it be backed up if the Account Name is used with empty field? Thanks, Than your only choice is to backup the project, and since you can't separate job...

Please state the format of the source data as well as the target. We don't know which timestamp you're talking about, Oracle, Sybase, DB2, etc. Plus, are you going to load it into the database using which stage? It's all important so that we can give you the right answer. Next time, please start a n...

If your data contains NULL, you can't do the equality as you've done. You must allow for the NULL condition. I suggest writing either a TRANSFORM or a FUNCTION to handle the comparison. Example function IsSame(Arg1,Arg2): Ans=If ISNULL(Arg1) AND ISNULL(Arg2) OR COMPARE(Arg1,Arg2,...

Caching a large file in memory is oxymoronic - you wouldn't do it. You cache highly repetitively accessed data, which large files tend NOT to be. Also, DS does not support read/write caching 64BIT hash files so it doesn't matter. Hash file performance is directly related to the amount of data on eac...

The FORMAL difference is that Server is the ETL tool used by over 2000 customers. Parallel is a separate tool that was purchased a few years back and "folded" into the suite. Parallel and Server are COMPLETELY separate ETL tools under the covers, with some limited overlap capability. Imagine two hou...

Hey Andy, if you have questions about posted shareware programs, you should address them directly to the folks who posted it. For CatDSX, that was developed by me and Steve Boyce, so you can ask your question to me, or go to the original post: m that supplied the logic and reference that when you po...

Just search this forum, there are many posts regarding this.

Read the file and use the Aggregator stage. Use the FIRST derivation for the phone number, group by the name. You'll only get the first phone number as output for each customer name.

Sure, depends on how complex your expressions will be. You can write a function to have a known set of operators, and simply parse the left side of the operator and the right side of the operator. Are you asking for help writing a function like this, or are you asking is there something built into D...

Look at this script, it shows you a good way to build a script to execute the dsjob command. You should form the entire command string and echo it, then execute it. That way you can debug it to see if it is formed correctly.

http://www.dsxchange.com/viewtopic.php?t=85578

Thanks guys. I'll be trying it later today and check back with what steps I had to take. Just to recap: 1. Chinese customer is using DS 7.5 Windoze Server and sent over a XML-DSX file full of Chinese characters. We were told they're using UTF8. 2. We setup a new DS 7.5 Windoze Server installation wi...