DSXchange

I have installed Datastage 7.5.1 in my pc. Now I am involved in a project that uses Datastage 5.2. So when I installed Datastage 5.2,I have issues getting back to Datastage 7.5.1 Can I use Datastage Multi Client Manager for this issue to be resolved? Or is there any better method where I can access ...

Hi, There are basically 2 things I wanted to know. 1.Where can i see the dsexport.exe or dscmdexport.exe file & what is the difference between the two? 2.Is there any way by which I can each and every transformation logic involved directly using either dsexport.exe or some other method because w...

Hi,
Can you type the command you are using for sending parmeters through unix and also mention the total parameters(name and expected value) used in your job.This can make things easy to give proper suggestion.

Even I am not very sure of XMigrator.I would want to know the approach without using that tool also.Thanks in advance for all the support.

Thanks ArndW.It would be really helpful if you can guide me the approach in brief.I know that 5.22 jobs will have to undergo through X Migrator.Then hotfixing of these raw migrated jobs has to be done.But is it necessary first i've to convert to 7.5.1 and then from 7.5.1 to 7.5.2.

Hi,
Need information whether I can migrate my Datastage 5.22 version to Datastage 7.5.2 Version directly.
Are there any problem invovled in migration?
Any help is appreciated.

Hi,
I know that Datastage uses the best possible type of Partitioning Mechanism when I give it as AUTO.
But I want to know which partitioning mechanism is actually getting used internally.
How can I see that?
Any help is appreciated.

ray.wurlod wrote:EXACTLY the same way you would do it in sqlplus or TOAD. ...

Can i do that using sqlldr and setting DIRECT=TRUE option for fast load?

Require help in inserting data into a nested table in oracle 10g database through datastage.
Thanks in advance

In the extended job properties - it's called Field Width. Right click on row in Columns grid and choose Edit Row... from the menu. ... Thanks Ray. I have set Field Width as you have told. Now Out of 5 rows in my seq file,i can only see 1st 2 rows. While trying to view data,the following warning mes...

Use Char, not VarChar, and specify the display widths. fname Char(4) width 4 mark Integer width 4 id Char(1) width 1 lname Char(4) width 4[/co ...[/quote] Hi Ray, Where can i specify display widths? :? like server jobs ,I do not have a display column here. Also I tried using everything as CHAR &...

Hi, I am having a fixed width file: File contains these three records ram1234 sam ra 123 1sam ram12342sam The metadata is: fname varchar 4 mark integer 4 id char 1 lname varchar4 In the Format tab I have set: at Record Level Record length=Fixed and at Field Defaults: Delimiter=none When i try view d...

Thanks !!! I tried the loop one. I am getting the desired output with the following code: $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSR_UVCONST.H $INCLUDE DSINCLUDE DSR_COMCONST.H PRINT 'FIRST LINE OF ROUTINE' RDT=RECDT HOUR=HR PRINT 'SECOND LINE OF ROUTINE' OPENSEQ'/u04/PRODDSS/data2/srcfi...

I have a file TestFile.
It has 10 records in it.
Using WRITESEQ I want to append 10 more lines in the file TestFile.
How is this possible??

I tried using the OPENSEQ before the loop and also closed before returning with the following routine. A=Arg1 A1=Field(A,',',1); *MDN A2=Field(A,',',2); *MIN A3=Field(A,',',3); *BUCKET ID with TILDE A4=Field(A,',',4); *BUCKET VAL with TILDE A5=Field(A,',',5); *COSID with TILDE B=DCount(A3,'~'); *Cou...