Doesn't work.
Like I said, I have tried with single, double triple quotes, /,\,space. It seems it is a bug in v8.1
Search found 25 matches
- Fri Jan 29, 2010 1:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: list of parameters in stored procedures
- Replies: 5
- Views: 3704
- Fri Jan 29, 2010 12:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: list of parameters in stored procedures
- Replies: 5
- Views: 3704
- Fri Jan 29, 2010 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: list of parameters in stored procedures
- Replies: 5
- Views: 3704
list of parameters in stored procedures
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...
- Wed Dec 09, 2009 1:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: v 8.1 sucks big time
- Replies: 4
- Views: 6504
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,...
- Tue Dec 08, 2009 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: v 8.1 sucks big time
- Replies: 4
- Views: 6504
v 8.1 sucks big time
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...
- Thu Mar 09, 2006 1:19 pm
- Forum: Data Quality Best Practices
- Topic: Running AuditStage jobs from within DataStage jobs
- Replies: 0
- Views: 14806
Running AuditStage jobs from within DataStage jobs
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
Just wanted to know if there's a way I can run AuditStage jobs from DataStage itself.
Thanks in advance
- Thu Feb 16, 2006 11:10 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Deploy through specific SFTP application
- Replies: 1
- Views: 3027
Deploy through specific SFTP application
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
Or Manual ftp is the only other option?
Thanks in advance
- Wed Feb 01, 2006 10:50 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Table Analysis
- Replies: 2
- Views: 4007
- Wed Feb 01, 2006 9:58 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Complex format files Profiling - addendum
- Replies: 3
- Views: 4762
Complex format files Profiling - addendum
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...
- Wed Feb 01, 2006 9:55 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Calling ProfileStage jobs from DataStage
- Replies: 5
- Views: 5115
Calling ProfileStage jobs from DataStage
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.
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.
- Thu Jan 26, 2006 1:03 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Table Analysis
- Replies: 2
- Views: 4007
Table Analysis
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...
- Wed Oct 12, 2005 12:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ds_ipcput - timeout waiting for mutex
- Replies: 18
- Views: 16547
mutex errors
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...
- Wed Oct 05, 2005 12:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Ports being used by DS
- Replies: 1
- Views: 1767
Ports being used by DS
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
- Mon Jul 11, 2005 8:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Environment Variable not working
- Replies: 9
- Views: 5085
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...
- Sat Jul 09, 2005 5:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Environment Variable not working
- Replies: 9
- Views: 5085
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#\#$...