DSXchange

View Data can be misleading. Use some other tool to confirm, something that will display space characers in some way.

Have you a NOWARN specification in your Modify stage?

Are you specifically handling null from input, even though you know it will never occur?

An Output tab is only pertinent for a SELECT. If you want to be updating, then your stage requres an Input tab. If the chosen action is update, then any columns that you define in your job design in the columns grid go into the UPDATE clause if they are not marked as Key into the WHERE clause if the...

The user ID you are using has never been granted CONNECT privilege.

What precisely do you mean by "create a project with an Admin account"?

Welcome aboard.

You ought to have no need to access these "internal" tables. The metadata are delivered without your intervention, for example via the metadata delivery and metadata analyis services (version .

Why do you believe you need to access them?

It's a huge topic.

Quod erat demonstrandum.

Are there any typos in the above? Why is the error message talking about decimal[1,0] when your specification states decimal[10,0]?

"Parameter not resolvable" probably means that you have used parameters for these three properties but, for whatever reason, the values supplied for the parameters (check in the job log) could not resolve into anything that the Oracle connection could use.

Does your stage have runtime column propagation (RCP) enabled?

Folks ought to be made aware that Brad's site was a Torrent customer (and therefore did everything with scripts and build operators) before they "came on board" when Ascential acquired Torrent Systems. That is, developers at Brad's site have considerable expertise in creating their own (bu...

Verr-rr-ry interesting! Will put this in favorites for next time I'm working at a Teradata site.

Isn't it too cold to type where you are?

I also think you need INSTANCE rather than INTERFACE in the WHERE clause, unless you've modified the file dictionary of DS_AUDIT. The table clause is correctly UNNEST DS_AUDIT ON MODS because MODS is the name of an association of multivalued columns - if you like, the sub-name of the nested table.

A Routine activity that did the same thing - either with a command or via BASIC statements such as OpenSeq - might be more flexible in terms of logging informative/alert messages. Of course you could also direct a trigger from the Execute Command activity to a logging routine activity.

Me - not at all. I get enough things to read as it is.

Grognard.

Can you successfully transfer the file using FTP without using DataStage?