DSXchange

Hi Probably you need to re-think about the administration and permissions in your projects. If you have an operator role, usually is because you have projects in production environment, where nobody "touch" the jobs, that's why Protected Projects has sense. The developers only should be al...

Hi I don't think Operator role will help you. DataStage Operators only can see jobs that had been released (option Release job). Whe you release a job, it is added subfix numbers to job's name (something like MyJob.15.1.0), this requests that you change the sequence job name that could be calling th...

Thanks Ray
I opened a PMR to investigate further this issue and ask for a workaround or something.
I let you know what I get from IBM support.
Regards
Cecilia

Hi Ray
Do you mean the Windows version or how Windows was configured?
Would this explain why the same happens with smat -s?
Thanks
Cecilia

Hi Ray
Nothing is reported by shrdump

Shared memory usage:
Maximum block used=1
id key Rev current .......

Regards
Cecilia

Hi Sriram Check if with Index function you can solve what you need: Index Function Returns the starting position of a substring. Syntax Index (string, substring, instance)string is the string or expression containing the substring. If string is a null value, 0 is returned. substring is the substring...

Hi Shruthija I have a customer with the same issue: No Type3 files active. He's running IS 8.1 Server on Windows 2003 platform and he gets no sempahores actives when run smat -s. Same results with smat -a. I found a post here: http://www.dsxchange.com/viewtopic.php?t=131006&highlight=smat+type++...

Last DataStage server version is 7.5.2 for any platform
Last DataStage enterprise (parallel) version is 7.5x2 for Windows 2003, but it's hard to make it works fine.

Hi, Even you can think you can know DataStage making a couple of jobs, this is a very powerful tool you never end to know deeply. The other "X-stages" products are complex too. These products belong now to IBM, then my best recomendation is to contact them for a demostration and explanatio...

The idea is to use Pivot stage (it's well documented in on-line help and manuals). In the Transform that follows to Pivot stage you can use MOD function to get each value and a Routin like I wrote below to assign specifics values (like column names) for each column. Sorry I can't develop all the pro...

Hi Narasimha Are you using Pivot stage to read each row from Excel and load it to SQL Server? When I had to do what I "guess" you are doing, I always should use Pivot stage. In that cases I needed the max number of columns, but didn't need its names. Could you please be more specific? Rega...

In my case, Ascential support suggested the change already posted:
LD_LIBRARY_PATH=/usr/lib/lwp:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

It worked fine for a couple of weeks, but as random behavior, it stands out from time to time.
The ticket was reopen.

Regards

PS: Sun Solaris

Hi When I was developing in a customer two years ago with Oracle DB, I had jobs with transaction size set in 0. When I run these jobs in Dev environment, if they abort, they rollback. When I run them in Prod environment, if they abort, the rollback doesn't happen and the inserted record, keep in the...

Hi Yallamanda My experience is that when MS takes long time in get the result from a query, is because MS Directory was corrupted during last import. If you have a previous backup, I suggest you to recover it and import again. Other thing you must have in mind is how big is the .dsx export file of D...

Hi First of all, if you are begining in use MetaStage, I suggest you to upgrade to 7.0.1 version which has many bugs fixed. About custome metabrokers, the manual is refered to metabrokers developed by the customer, not provided for Ascential. For instance, if you wanted to import metadata from SAS o...