DSXchange

Hello, I mean on teh ''view detail'' of a job on the web console it is empty on the log and saying ''never run'' on the details tab. Also on the job run part of the window you do not see any information exept 'no job run found'. I do have a print screen showing that the sequencer ran the job success...

Hello,
I was wondering if anyone had an issue with the web console not showing any information on a parallel job that just ran.
The job has been started by a sequencer and finished successfully, but shows as never run on on the web console...

In the Director the log is fine.

Regards

Sorry my mistake on the COBOL is reading COMP....
I misstyped when creating the post.

The source file is containing only numbers. No special chars

Tony

Hello, I'm using a job reading a COBOL file PxCFF. I read a column PIC 9(13)V9(4) COP-3. Metadata for this columns are defined as follow 'Decimal (17,4)' in DataStage and in the DB. When I read the COBOL file I retrieve only 0000000000000.0000 even if there is different data in the file!? I've an ot...

Okey,
Yes holding the last value is fine too.
I've found the following routine 'RowProcGetPreviousValue' but it only works on server job... Is the something identical for parallel jobs?

Regards

Hello,
I want to create a jobs that reads a row from a file in one column and in an other the row-1..

Ex. Data1, Data2
1 Null()
2 1
3 2
... ...

If you have any advice on how to build something like that?
Thanks,

There is a configurable limit to the PRECISION (number of significant digits) in DataStage BASIC. What happens when you use SSub( string1 , string2 ) function, where the two arguments are your two numbers? This is an example of DataStage's "string math" functions, which can be used to get...

Any 'calculation' in particular or do we get to figure that out? :? The calculation is a simple minus. I try to make a simple job with this query : SELECT 1324414646, 1301128551.1 FROM DUAL I send the result in a flat file then i made the minus in the transformer and i send to another flat file wit...

Hello, I have to do a simple calculation with 2 field. The first field is a decimal(30,8 ) the second one is a decimal(30,8 ) too. The value of the first field is : 1324414646 The value of the second field is : 1301128551.1 The result is : 23286094.9000001 Edit : Oups.. The calculation is field one ...

It' s work with :

uuencode "FilenameWithPath" "FileNameInMail" | mailx -s "MailSubject" "Recipient"

But juste for one attached file.

Thanks

Thanks a lot

I'll investigate yours answers.

Hello

I try to look for an answer in the forum but I only found for 7.5.
Is there any possibility to attach a file with DSSendmail or with Notification Activity ?

Thanks

Hi , I wanted to do a self join with a table which it is having data around 10 crores of rows. ,Which is the best method to do that. Please suggest.. Thanks in advance.. Sorry, but could you please specify what are 10 crores ? 10 millions rows ? In that case I would check if this is really usefull ...

What about the LOG ? Do you have any warning messages (from the DB ? ) ?

What do you mean by not able to run it again ?

Hi vijaynaidu, I used to work for SAS in the past and what I can say is that basically DataStage and SAS are not really the same, if we want to compare them. If you need a powerfull and intuivite ETL-EAI tool, this is DataStage and if you need a fully complete solution, from data extraction up to cu...