DSXchange

Look at the second case study in the Pivot Stage manual (pivot.pdf). It is exactly this scenario. A Pivot key, a non-pivoting column, and a pivoting column. ... Ray, Is this the one you are talking about , I got from pdf Payments Example CUSTID LNAME JAN_Sales FEB_Sales MARCH_ Sales JUN_Pay DEC_Pay...

velagapudi_k wrote:Thanks a lot ArndW. It worked.

Can you please send me details of "LIST_READU" command how it worked for you....

Thanks,
Anupam

pkomalla wrote:" unexpected explicit item id".

Hi,

This error comes when you specify wrong column in select tab.
Please see column name in column tab of hash file and specify correct column name in selection tab.


Thanks,
Anupam

I think pivot stage present in server jobs cannot perform this task...
If you think so please post me steps.
As per i know you need to go with some variable and aggreagator calculation.

Thanks,
Anupam

Hi richa,

Search my last week reply for above .....

Thanks,
Anupam

Hi,

Looks like you modify dssendmail_template.txt file.

Copy dssendmail_template.txt from template to project->project_name folder dont change anything in file dssendmail_template.txt . It will work..

Thanks,
Anupam
akarmarkar@smart-bridge.co.in

Why dont you try to write in source query that where key column is not null.

Thanks,
Anupam

Hi,

Also try in datastage administrator command:

LIST.READU

get the information about job which are lock

from the above command you will get USERNO

to unlock job use following command

UNLOCK USER USERNO


Thanks,
Anupam

Why do you think so? Could you be more specific. The date provided by you is only 6 characters where as the format you are talking about"CCYYDDD" is 7 characters. Also, CCYYDDD implies CC= Century YY=Year DDD= day of the year and that matches correctly with the data(2006079) I provided. P...

chulett wrote:No, don't use the package installer for reasons I don't have time to list here. Repeat the server install, it's painless.

No craig, using Package installer it is also easy to install Plugin But select Folder name like STP not I386 as path...

Thanks,
Anupam

Hi,

Are you using before/after subroutine or notification activity in Job sequencer. Error is not clear because notification activity never user sendmail_email.bat file....


Thanks,
Anupam

While installing it will display all plugin's. You might have miss that..

Use package installer to install plugin's, stored procedure plugin name is STP, it will be available in software as it is default plugin.


Thanks,
Anupam

Hi,

Use substring function in transformer to extract time from Date like
example :substring("1/1/1970 10:31:00 PM",10,11)


Thanks,
Anupam

Hi,

Container input link name and Input link inside container must have same name.... I think you might have given different name for both..


Thanks,
Anupam

soham296 wrote:Hi,

Can someone tell me, from exactly which version of Server Edition do we have Stored Procedure Stage. Do we have SP suppport in 7.5 ?? Or from 7.5.x ?? Thanks

From Datastage 7.5

Thanks,
Anupam