Search found 25 matches

by dscnn
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: 2491

Doesn't work.

Like I said, I have tried with single, double triple quotes, /,\,space. It seems it is a bug in v8.1
by dscnn
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: 2491

Yes! Apparantly a single quote Is the escape character, otherwise I have tried /\ spaces, you name it.
by dscnn
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: 2491

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 valid property list: Expected "," or "}", got: "'1'"

Any ideas how I can pass the values in this variable?
fyi, the SP works when executed from DB2 Toad: CALL schema.testsp('''1'',''2''')

Thanks in advance
by dscnn
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: 2008

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, Transformer is not handling the stage variables correctly. Its assigning incorrect values to many data rows (same data that passed properly in v7.1 and gave desired results).
by dscnn
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: 2008

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 of stuff around it whic is great, but it is ruining the core which made DS a great product in the first place.

Just my 2 c of whine for the day.
by dscnn
Thu Mar 09, 2006 1:19 pm
Forum: Data Quality Best Practices
Topic: Running AuditStage jobs from within DataStage jobs
Replies: 0
Views: 6338

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
by dscnn
Thu Feb 16, 2006 11:10 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Deploy through specific SFTP application
Replies: 1
Views: 2013

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
by dscnn
Wed Feb 01, 2006 10:50 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Table Analysis
Replies: 2
Views: 2523

Thanks Roy,

It was the review which needed to be completed.

roy wrote:Hi,
Did you mark the review as accepted?
IHTH,
by dscnn
Wed Feb 01, 2006 9:58 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Complex format files Profiling - addendum
Replies: 3
Views: 2957

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 data? All help would be greatly appreciated.
by dscnn
Wed Feb 01, 2006 9:55 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Calling ProfileStage jobs from DataStage
Replies: 5
Views: 3053

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.
by dscnn
Thu Jan 26, 2006 1:03 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Table Analysis
Replies: 2
Views: 2523

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 analysis can be done? Or give the steps here. The document I have tells the step by step method for the column analysis, but not any other.

Any help would be greatly appreciated.
by dscnn
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: 13896

mutex errors

Where are the SPINTRIES, SPINSLEEP and other parameters adjusted? Which file on the server or the place on Administrator?

ray.wurlod wrote: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 parameters?
by dscnn
Wed Oct 05, 2005 12:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Ports being used by DS
Replies: 1
Views: 1172

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
by dscnn
Mon Jul 11, 2005 8:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Environment Variable not working
Replies: 9
Views: 3424

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 know.

elavenil wrote:We are exactly doing as mentioned in the post but not as environment variables as parameters. #$A#\#$B#\#$C should work. This would give a problem, if your OS gets changed from windows to UNIX. So i would suggest you to have another variable to store directory separator so that you do not need to change the job even if your OS changed.

HTWH.

Regards
Saravanan
by dscnn
Sat Jul 09, 2005 5:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Environment Variable not working
Replies: 9
Views: 3424

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#\#$B#\#$C# in my DS Administrator, which I'll do Monday morning.

In short, I am really looking for a way to use the values of env variables in other env variables themselves.

amsh76 wrote:Why can't you keep it like following:

#$A#\#$B#\#$C#....whats wrong in this? This takes care of your problem.