DSXchange

They are. We use the term "Shared Tables" to describe the tables that are central to all the tooling within Information Server. Shared Tables are equivalent to "Database Tables" in the InfoSphere Metadata Workbench. Once they are imported and visible in the Workbench, they will a...

Do you have any xmlOutput Stage working? Did this one ever work prior to implementing the trigger?

Ernie

see what happens if you use varchar on the final link instead...perhaps trimming it beforehand if necessary. You will have to redeploy the application.

Ernie

hex 40's are mainframe EBCDIC blanks... you probably want hex 20's (ASCII blanks). Or just use a single space in the display editor. Internally it should be a hex 20.

Ernie

One additional note....I had a funny thing happen once with this variable where I had to set it to a single space.....with no quotes.....to get it to work.

Ernie

HI Ray...

Curious, as I've never seen this error.......did it matter what bridge you were trying to use?

Ernie

3. is more flexible with large, randomly variable varchar columns (thousands of characters).

4. Has more options in current and older releases for transaction management and really specific "row by row" control of flow.

Could be lots of things. While you are debugging you might want to start a new thread on the techniques you are using in the Job, as this particular issue is not ISD related.

Ernie

I haven't heard of any of those issues...they might be related to the problems you are having with the URL. Of course, try your best to get up to 8.1.1 and/or go right to 8.1.2. 8.1.1 is already over a year old. I'm not aware of patches to such issues as you are having, but I haven't seen them eithe...

Exactly what release are you on?

Hmm.. ok...indeed, you are doing it correctly. What exact release are you on? I haven't seen an error at that point --- it's more common to see that no tables come up on the list.. Clearly that is not your issue. It may be time to call support on this one..... ...I hope also that you are on 8.1, pre...

are you putting just the filename into the External Source? ....or an "ls" command that points to that filename....re-read the post that craig pointed to above. It sounds like you are just putting in the filename.

Ernie

Yes.......except you may have a metadata mismatch in workbench when trying to assign the "Shared Table" to your Sequential Stage..... ...here's the big question....after you created the Shared resource, can you see it under "hosts"? ...if so, does it have Host - Database - Schema...

Data Item Binding manually connects a "Stage" to a "Shared Table" Should work fine provided that you select a "like" stage type to the resource you are binding.....so...if you have a relational Stage (ODBC, Oracle, DB2, Teradata, etc.), select it and then find a Shared ...

no....I just mean, check carefully what the null representation is when it goes out to your flat file. Make sure it's not binary zeros. Blanks would be good. Find out what your client tools are expecting for "null".

Ernie