DSXchange

Any way other than compiling a C++ program? No, not in this context.

Are you certain you need to be creating any such thing? What are you trying to accomplish?

Please define what you mean by "search the DataStage job".

Interesting.

johm73 wrote:I did this in the same manner I created all the other projects in the past.

And that would be?

throbinson wrote:Parameters will work within the description field.

Interesting... makes sense that something like that *could* work but I never had a need to try any such thing. Curious how that works out.

Read it as fixed-width.

Yes. They may simply need to be compiled for some reason and that tool could do them all in one shot.

Or maybe you just need to read it as a fixed-width file. Can you post examples please of what you are looking at, before and after?

No idea what that means.

Can you provide an example or three? Something to show us, make us understand what "a series of data coming in for different column fields" would mean? Thanks.

So, it's not that it didn't work, they don't even want to try it. Nice. Maybe you just need a patch, if there is some kind of "known issue" with doing an alter like that. Any way, have fun exploring!

An export of the entire project is what should have been used and it would then have included all routines as well as jobs, etc. First you need to check and see if those routines are truly missing from the project or not, if they are missing then go back and have them exported / imported for you. So...

ds_teg wrote:we can use alter table even though there is data in the table. But for some unknown reason that is rejected.

Me, I would spend some time to figure out why it was "rejected", there's no reason a simple alter to increase a field size should involve copying billions of records.

Please start a new post when you have new questions or issues.

Those errors are because you have "user defined" routines that are either missing or are not compiled. Specifically, from your example, one named "ValidateOWELkp". How exactly did you "upgrade"? For a minor release like that, it really should just have been a "upgr...

Just like any other stage, you either need to import the metadata or enter it manually. And "secure" tranfers (like sftp or scp) don't use passwords in a non-interactive mode.

No, that's how you pass it from Job1 to Job2 in the Sequence. I want to know what you are doing inside Job1 to set it.