DSXchange

Please find the details and help me out.

System:
Microsoft Windows XP Professional Version 2002
Service pack 2

Operting system(Client): Windows XP

Could you please tell me how to get "service pack level" info .

Could you please tell me.Is this from Server problem or Client problem.

Please help me out from this problem.

Hi,

We have installed the Datastage(8.0.1) on SunOS.We are getting some probles.

1) Once design the job we are able to see the stages and links. once I closed the designer and re-opening the same job, we are unable to see the links and stages.

pls send the e-mail id and details

Hay, Make sure that....Keys should be the same order,While parition the data ----- |DB2| ----- | order like A and B ------ |Sort2| ----- | |DS of 1 | -->(A and B) | Sort1 |-->|join | ---> |ouput |

Hay, Below is the routine for getting the count from the link. Jobname and linklist is the args. $INCLUDE DSINCLUDE JOBCONTROL.H * Check for empty JobName If JobName = "" Then Goto ERROR * Attach the job JobHandle = DSAttachJob(JobName,DSJ.ERRFATAL) * Get the number of links to process Row...

Hay,

Use the below one.


IBT_MAT_DT = date_from_string [%mm/%dd/%yyyy] MATDT

Hi All,

Pls tell me tunning techniques in PX job.

How to tunning the job.

As of now i am using source and target is below.

Delimeted file
Fixed lenth file
Oracle
DB2

Please advise me ....

Thanks and Regards,
Ravi Babu.B

Hay,

If you ant follow the steps...

!) Find the number of records in file.
2) take a last line of the file. mean ...line number = count.

then read the character..

Hay ,

Use the Type conversion function like stringtodate and datetosting.


Bye

hI,

You select the Nullable is YES and your not handleng the NUlls in Format tab.

Pls select the Field default then Null fileld Value="\000"

Regards,
Ravi Babu.B

Hi ,


Use the below logic .


@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1

Hay,


Pls, Think and post the question.


Thanks

Hi,

Pls,use the pivot and change the Row--->Col

than import from manager.

Thanks