DSXchange

Use the DSAPI functions to interrogate the "summary of sequence run" event from the end of the sequence's log.

What Eric said. The appearance of "1X0X" later in my post may have given you a clue.

My guess is that your Postcode field is defined as Char data type and that the value of APT_STRING_PADCHAR in your project is 0x00 (which pads Char fields with NUL characters). Quick fix is to change APT_STRING_PADCHAR to the space character or to 0x20 (equivalent). Otherwise you can explicitly pad ...

The error message suggests that the project name (the value of %Project%) was wrong the first time around. Project names in DataStage are case sensitive. Perhaps you had the casing incorrect?

Best practice is to have one WAS instance and one XMETA database to control as many engines as you have. Or, perhaps, one for production and one for all non-production environments.

Yes, you can save the schema file from a DataStage table definition. Go to the Layout tab and choose the Parallel option. Copy the schema definition from there to wherever you need it. Or right click in the schema and choose Save As... from the menu to save the schema file on your client machine. No...

Arg1 Matches "0X'_SRC_STG|'0X'_SRC_LNK|'0X'_TGT_STG|'0X'_TGT_LNK'" The pattern element 0X matches any number of characters. If you require there to be more than zero characters, change each "0X" to "1X0X". You can use "..." in place of "0X". This po...

DataStage does not have any capability to generate GUID values.

There are several strategies you could use to have DataStage query the database for a GUID value.

It is true that they are not the same database; you can most easily prove this by looking at the shared memory keys. I can't think of anything else to suggest. There is no "DataStage ODBC driver".

That error is almost certainly in the client software rather than in anything in the analysis software.

As noted, you'll need to contact your support provider.

Some other options:
(1) get "them" to supply cleaner data
(2) specify pipe as Record Delimiter property value and pre-filter the newline characters from the file (perhaps using tr -d command as the Filter command in the Sequential File stage)

Do you have a question, or are you simply advising that this behaviour can occur?

It's not clear (from your examples, anyway) which data belongs in which column.

You may be better off, once you've identified all the variants, to read each line as a single VarChar and do the parsing in a Transformer stage.

If nothing else, your parsing will be executing in parallel.

I'm not aware of any web service that can accept a file.

I guess that's why there exists an ftp protocol as well as http.

Perhaps I've had a protected existence.

Small correction to the roles for 11.3. Steward cannot create terms - this is the Author role. Steward is not actually a role. The Business Glossary roles are replaced by the Information Governance Catalog roles. Here's a list: Information Governance Catalog Glossary Basic User Information Governanc...