DSXchange

No sure but to identify an individual character outside of the standard Ascii you could try
Not had to do it before though.

Ok you need one more stage varible to produce the row numbers

svRowNumber = If svIsNewValue Then 1 Else svRowNumber + 1

I don't understand why this shows no partitioning by keys. Have you setup the sort and aggregator correctly with the key/group columns specified? I would expect there to be an entry in the SCORE similar to APT_HashPartitioner { key={ value=key_field, subArgs={ asc } to show that DS will partition by...

Have a look at this link which will explain how to check and change the soft and hard limits.

http://www.ss64.com/bash/ulimit.html

As Craig said, you probably need to get SA to do this for you.

So the job runs and records are updated in the database but then it throws a warning at the end? Have you tried running it with just one record which you know performs an update? Does the warning still occur? It may be data related, otherwise not sure why it would work for some records and then thro...

Your hitting the 2GB file size limit imposed on you by the UNIX setup. I think this is set through ulimit(). I can't remember now if this is just setup once or whether it is specified in dsenv and I don't have a system to look at now. Will have to check in the morning unless someone else answers thi...

Open the entry and paste the text that is inside!

Transformer with input link and 3 output links for your 3 files. Stage Variables as follows svCounter = If svCounter = 10 Then 1 Else svCounter + 1 (set the default value to 1) svActiveLink = If svCounter = 1 and svActiveLink = 3 Then 1 Else If svCounter = 1 Then svActiveLink + 1 Else svActiveLink A...

Just to resolve this, the workaround if you are having the same issue is to use a sequential file stage instead of the row_merge/row_split stages, just with different metadata on the write and read side.

The answers not quite as simple as that

Was commenting on initial post not your response Ray!

The answers not quite as simple as that, it depends on the volumes of data you have in your two datasets, what the distinct set of key values are, and what type of actions you want when matches aren't found. Depending on the answers to these questions you can use the JOIN, LOOKUP or MERGE stage to j...

George is right, first sort the data by key fields. I wouldn't use the row compare routine though as it will be quicker to use stage variables to compare the current value with the previous value. svPreviousValue = svCurrentValue svCurrentValue = input_rec.value have the stage variables in that orde...

Add the environment variable APT_DUMP_SCORE to your job, APT_DUMP_SCORE (Hint: This is in Parallel/Reporting" section) and set the value to True.

Run the job. One of the entries in the job log will start "main_program: this step has ? datasets"

Copy the content of this entry.

This is documented in the dsupgde.pdf. You need to add an entry to the .odbc.ini file in the DSHOME directory. You will find an example entry for MS Sql Server, just copy that and add your relevant values. You may also want to add entry to the uvodbc.config file so that the connection appears in the...

I also found this very annoying that you couldn't define your own criteria for when a job should be re-run. i.e. if it finished with any status other than OK. I don't have the code with me now and don't have EE here so can't give exact code, but I wrote a routine that would clear the 'Checkpoint' fr...