DSXchange

In SQL Server an identity column automatically generates sequence numbers when rows are inserted. In normal operation you leave it out of the insert column list so that SQL Server sets it. If you are doing data conversion you may want to explicitely set this value, for example you want to retain th...

jzparad wrote:Isn't this just a string concatenation?

Well I was trying to actually get the time portion. If you mean just concatenating the string '00:00:00.000' in this example, that wouldn't fit the requirements.

(Guess I need to be more specific :D

Anyone know the code to turn a Timestamp that looks like this:

2005-05-29

Into this:

2005-05-29 00:00:00.000

We've recently installed XMLPACK 2.0, and we are building our first jobs. So far the product has seemed confusing and counterintuitive. We have not been able to even get the simplest XML extract stage running. :x My question: Does the DSX community consider XMLPACK to be a viable solution or should ...

I wanted to give everyone an update on this. Our DataStage administrators installed upgraded 64 bit ODBC drivers that Ascential provided. That resolved the issue.

By the way, the actual problem was an error message that caused the job to abort (not just a warning message in the log).

I believe that you need to have your logging on to get rid of 'transaction not available'. Thanks for the response. Are you basically saying that DataStage is not able to read data from a non-logging Informix database? That sounds a little crazy to me if that is the case. Can anyone confirm this?

We've recently upgraded our Informix server to 9.40 FC5 64 bit. Now an extract job that previously worked does not work anymore. I haven't tried the job in several months, so I cannot be sure that the upgrade is causing the error. Here's the story: 1 - I have an ODBC stage that selects from an Infor...

I have multiple records per individual, based on an individual type. Each one will either be A or I. (Active or inactive.) I need to boil that down to one record per individual, that follows this business rule: "If an individual has any active records, they are active." i.e. Three records:...

In a server job, I have a sequential file that feeds an ODBC stage. The ODBC stage uses the update action "Update existing rows only". Since I am re-using this sequential file in a later process, I would like to have more input columns than are used in the update. (i.e. 5 columns in sequen...

We have a sequence job that sends an email using the "NotificationActivity" stage. This is a parameterized job, so it is executed 6 times with different parameters. (Jobs are set to allow multiple instances.) (I've removed some of the actual path names) processPLASOfficeUpdates.processPLAS...

kduke wrote:Ray posted some code where he dumped DS_METADATA file into XML. It was all written in BASIC. Very clean easy to read. Do a search.

I searched for it and found a link to that topic, but the link was dead. Anyone have a hint how I can track it down?

ogmios wrote: If you write your own XML files via a BASIC job nothing

Have any sample code you can share?

What addons do I need to generate XML files in 6.x?

I have a sequence job that controls the flow of my process with multiple JobActivity activities. Each JobActivity has a trigger if the server job it calls doesn't return OK. These triggers all feed into a Sequencer activity that activates a generic error email. Question: how do I go about retrieving...

We have a sequence job that cleans up files by moving them to a "complete" directory. We accomplish this with an "ExecuteCommand" stage that issues a command like this: "mv somepath/someprefix_*.dat somepath/complete". This works fine, but I would like to use parameters...