DSXchange

Doesn't work.

Like I said, I have tried with single, double triple quotes, /,\,space. It seems it is a bug in v8.1

Yes! Apparantly a single quote Is the escape character, otherwise I have tried /\ spaces, you name it.

I am trying to pass a list of string parameters in a stored procedure, which will be used in IN clause inside my SP SQL. It used to work in v7 but isn't in v8. Example, CALL schema.testsp('#pINSQLList#'); while running, I am giving value of parameter as ''1'',''2''. Its failing with error } is not a...

Almost all stages are having problem. For example, When I partition data in a Sort stage (Partitioned on Id, sorted on Id, Sub Id) and later move to a remove duplicate (Partition as Same) where I want to keep only the Last of the dataset with same Id, its picking up some random row. Another example,...

We have been working on v 8.1 after upgrading from v8.0.1. We are finding that most of the partitioning inside stages has so many bugs in it that its unbelievable. The partitioning does not work properly, even though same scripts and stages definitions worked fine in 7.1 and 8.0.1 IBM is putting lot...

I'll be installing AuditStage on Solaris box soon.

Just wanted to know if there's a way I can run AuditStage jobs from DataStage itself.

Thanks in advance

Is there a way I can deploy my maps and msl to the server by using secure FTP applications that the client uses?

Or Manual ftp is the only other option?

Thanks in advance

Thanks Roy,

It was the review which needed to be completed.

roy wrote:Hi,
Did you mark the review as accepted?
IHTH,

I have a complex file that needs to be profiled. There is a post on this earlier and it was suggested to break up similar rows into seperate bunches and then profile them. But what is the use of buying the tool if it has to be done manually? Is there any other better way to profile complex format da...

Hi,

Can ProfileStage jobs be called from DataStage? How to call them, if it is possible? I can't see anything about it in ProfileStage documentation.

We are using IBM ProfileStage and new to the tool, and I've installed a windows version. I was able to do the column analysis, but am not able to do the same thing for further analysis example, table analysis, primary key, et al. Can someone point me to the right document whch tells how the table an...

Where are the SPINTRIES, SPINSLEEP and other parameters adjusted? Which file on the server or the place on Administrator? After changing SYNCALOC, did you run uvregen and re-start DataStage? If not, your SYNCALOC change will not have taken effect. Have you adjusted the SPINTRIES and/or SPINSLEEP par...

I need a lost of ports that should be opened on teh production box for running DataStage. Is there a way I can do that. I have no other extra stages apart from those in the standard EPM package of DataStage. The productoin is AIX

Hi Saravanan, I am trying to use #$D# directly in my Sequential Stage instead of #$A#\#$B#\#$C# and D = $A\$B\$C in DS Administrator is being defined. I really need help on this fast, or atleast someone to tell me that it cannot work this way. If it works a step by step approach will be great to kno...

Our directotry structures can change a lot. We are using $D as the paths in out Sequential Stage and are trying to fill D in DS Administrator itself, by using othe env variables as decribed above. We don't want to change the jobs if the structure changes each time. Although I haven't tried D=#$A#\#$...