DSXchange

'Abnormal termination' errors are practically always associated with Transformers as they are an active stage. What happens if you Reset the job after it aborts? Do this from the Director and then look for a new log entry labelled 'From previous run...', it can shed some additional light on the prob...

dhiren wrote:... and have included Database and Schema name before the statement...

Don't.

There are options in Version Control to handle deleting 'components' from the repository. One is to allow it, so the first step is to turn that option on. And then since it is a version control system, it still shows the component as 'deleted' in the browser. There is yet-another-option to not displ...

maffan76 wrote:I have read posts suggesting make one file as HASH and then joining with other file but as per documentation HASH file can have only 1 column as key.

Not sure where you read that, but it is incorrect... hashed file stages support multiple key columns.

Yes, there are Looping stages that were introduced in the 7.5 Sequencer which as you noted won't help you with this. For you, hand-coded job control could handle that requirement. If you want to do this in a job, search the forum for usage of the 'UtilityRunJob' sdk routine, it will allow you fulfil...

As Roy notes, the 'official' answer is to purchase the SOA Edition. Out of the box it enables you to expose a DataStage as a web service, the ability to call a web service from a DataStage job is optional... and extra, of course.

I'm sure it's listed in the install guide(s) somewhere, but you can also search the forum here and turn them up.

The client needs to connect to the server, there is the standard telnet port and then the PX 'jobmon' has its own ports. Not sure if there are others.

What you are calling 'blank' is an 'empty string' and is a known value. Null is the unknown value and is tested for using the IsNull function.

Use the same hashed file with multiple links.

chulett wrote:What does your metadata in the Sequential File stage look like? One big column?

Survey says?

Try bringing in the entire XML record in as one field and hooking them together as noted by lstsaur, let us know how that goes.

Umm... what happened to the Folder stage up front? I really don't think you can feed an XML Input stage from a Sequential File stage...

What does your metadata in the Sequential File stage look like? One big column?

No idea what you are seeing. Can you check this post for a way to post a picture of the insides of your transformer? Look near the bottom of the first page for talk about places like ImageShack and you'll see it is very easy to accomplish. Then maybe we'd be able to help. At worst case you may need...

Not sure how you wouldn't be able to see that... perhaps that bottom panel is slid 'all the way down'?

Regardless, you should be able to make the change from stages on either end of the transformer.

You've defined a column and didn't specify a size.

As does the FMT command.