DSXchange

I used the Job Control to call all the BATCh job in a sequence While compiling the main job ,It throws me Errors based on parameter, '$' unexpected, Was expecting: ')', ',' 0271 ErrCode = DSSetParam(hJob5, "$OracleUser", $OracleUser) Can anyone have an Idea regarding this? Thanks in Advanc...

It is job that extracts the records from Oracle Db and load it into a Dataset. I cant able to view the records in the dataset link. It throws the above mentioned ERROR!!

How can i overcome this problem

I Could not able to view the files in the job ,So i tried to copy the job and tried to view the records..!!

I have not changed anything... It is a Production job and it was running in a daily schedule..

Hence i copied it and tried to compile and run!!

But i could not able to run...

I got this error for all the jobs in that project. There is another Error following the above mentioned error!!! Error calling subroutine: DSD.Browse (Action=5); check DataStage is set up correctly in project Retek_ETL_PRE Warning: Data that exceeds the maximum display length has been truncated. Act...

Hi all, i tried to copy an existing job and run.. But it throws an error and Warning ...and Aborts Error: Error setting up internal communications (fifo RT_SCTEMP/DS_Test.fifo) Warning : Attempting to Cleanup after ABORT raised in stage DS_Test. I could not able to locate where the problem is? Can a...

Hi all , When i try to view the records in a dataset using "View Data", I got an error as follows, Error calling subroutine: DSD.Browse (Action=5); check DataStage is set up correctly in project ETL_DEV I checked with other projects and i can able to view the records in the dataset. Can an...

What datatype are you using to define it the DS

After getting output like this,
Col
A
10
A
20
A
30
B
40
B
50
.
.
.

You can use remove duplicate stage (Provided the records in the column 2 have no duplicates!!)

You can use PIVOT Stage!

Then try to map the Varchar Column to Decimal without using any function to the target file. For your records your varchar(9) should be mapped to Decimal(6,2)

I do had a situation like you, and used the above solution which worked fine! (In 7x)

puliram wrote: Just let me know the format of stringtodecimal syntax, though its is clear in help, its not helping much.

Can you post the conversion syntax that you have used?

Actually,In 7x, we dont need any conversion function,as this can be done in the implicit conversion.

Can you able to see the records in the sequential file ?. If not then check with the metadata you have mentioned and then we can go for the type conversion!!

As you read the column as Varchar, you can convert it using the Type conversion technique. Do you get the whole value as Varchar(Including the decimal value)?

The Problem is solved ....Actually there are some spaces and hence i tried the followingand it is fine now!!

Trim((TrimLeadingTrailing(Link1.Column)),'0',"L")

Thanks for your comments,