DSXchange

Nested Ereplace() functions should do it. For example, and not including " A ":

Can you try renaming the file, perhaps to A3.txt ? ODBC in particular does not like identifiers beginning with numeric characters.

srinath0253 wrote:Hi Ray,

Can you post the code for public. Im not premium user.

Hi Srinath,

Can you become a premium member? This is the funding mechanism that keeps DSXchange alive.

Basically it's a whole heap of If..Then..Else expressions that test the field number associated with the specific column heading and, where appropriate, use the Field() function to extract that particular substring out of the single VarChar input column.

Each "(" is converted to "-", each ")" is converted to "" (removed), and each "$" is converted to "" (removed).

Resolved? If yes, please mark this post as resolved using the green button.

You could script the exports that Arnd mentioned, backup the entire project, then delete and re-create the projects and import from the exported jobs.

Have you tried importing using Metadata Asset Manager?

Have you used the "discover flat file" option in the IA tasks menu, which builds/maintains the QETXT.INI file?

The workaround was marked before I posted.

If you are using the DataStage Operations Console then all these data are being automatically collected and stored in the DataStage Operations database (DSODB). The structure of this database is completely documented, so you should be able report directly from it.

Ah, the old "dirty handle" problem again.

There's obviously some kind of problem with the data in the NEW_STATUS field.

Apart from the mismatched quote, the hex representation looks OK (all of the byte representations are below 256).

What do you see for this value when you select directly from Oracle, for example using TOAD?

Just to clarify, by default job log auto purge only occurs when the job finishes WITHOUT FAILURE.

If the job aborts, crashes or is stopped, no entries are purged from the job log.

In addition to what Arnd suggested, remember that stages, links, containers and annotations are stored in DS_JOBOBJECTS, so you need to delete entries from that table, ideally before removing the entry from DS_JOBS. I haven't tried this but, knowing that you can delete a job in Director client, can ...

My guess is that Multi Client Manager did not install correctly. Check your installation log. The easiest remedy may be to re-install the client tier 11.3 software.