DSXchange

Hi All, I am trying to execute a Sql-Server Stored procedure from Datasage parallel job and my job is like this:- RowGen(1 row) ---->Stored Procedure stage ----> peek stage I have imported the metadata from TableDefinition--> Stored Procedure Def. I have selected below setting in StoredProcedure Sta...

Hi,

does Datastage partitions data as well when it has to sort data?

Yes, datastage parallel sort stage implicitly places hash partition on input of the sort stage and hence auto partition will perform Hash partition.

Hi,

Try to read the file with comma delimited and do not mention double quote in the job in file definition.

Later in transformer you can handle quote character.

Dear All, I have a job where source is ODBC Connector stage(Sql Server) and target is sequential file. I need to generate the file and data is around 4GB. This file will be used by downstream system. My job is working fine for sometime but later it is aborting with below error message:- SendWriteSig...

Hi,

Please let us know what was your approach to get the output.

When is the interview?

Sort Aggregator is the method of doing aggregation(aggregator stage), basically there are two methods:- Sort Aggregator Hash Aggregator Sort Aggregator is useful if you have more number of groups. In case of sort aggregator, all grouping columns need to be presorted and partitioned, and stage will o...

Yes

Hi, @NUMPARTITIONS is the count of number of partition used in your job design. If your number of partitions are 4 then @NUMPARTITIONS=4 @PARTITIONNUM will be 0 for first partition and 1 for second partition and so on. Using @NUMPARTITIONS,@PARTITIONNUM and @INROWNUM you can generate formula to crea...

Hi All, I have sql server stored procedure which will i need to execute, but in datastage 7.5 version i am struggling to design parallel job. It working fine with server odbc stage but i am advised not to use server job. Is there any way i can it in srever routine and call in job's before jobs subro...

Yes you need to recompile all old N jobs which are using same parameter set.

Hi,

I have no idea if you can use XMETA databse for this but you can create other schema and define you tables according to your schema definition.

Hi,

I have used java code to generate GUID in my project, and it is working impressivly.

Let me know if you need a code.

If you can add indicator column in source table (eg Indicator='P') then your work will be very easy. 1.Intially flag all indicator to Indicator='P' then add this in your db2 select statement where clause. 2. Select ROWID from source table and in you job store it in dataset. 3. Design post update job...

Hi,
How are you currently running your job,i mean how are you passing multiple messages in MQ?

Are you using message segmenation feature?