DSXchange

Hi All, The job is actually reading from a fixed width file with all the columns as char fields. I am able to read the file correctly. I have a transformer after that that adds 2 new columns with some constant values. Also convert the incoming columns to Varch fields so that I can extend the width o...

I am not able to read from the target fixed width file. I was able to do it few hours ago.The job runs successfully without warnings. Get this message when try to view the data. /u001/dev/Ascential/DataStage/PXEngine/etc/standalone.sh -APT_PMsetupFailedFlag /u001/dev/Ascential/DataStage/PXEngine/bin...

Hi All, I have the following data 00999(JP.VAPRL00001VRNM 000012003-08-052799-12-31 OTHER AGREEMENT 00999(JP.VAPRL00001VRNM 000022003-08-052799-12-31 ARTICLES OF ORGANIZATION 00999+"%&M0B7.00001NDLC 000012007-02-192011-02-19CAC123456789 have this record layout ID-TB 1 77 A BASE-KEY 1 19 A C...

Hi,
Thats an alternative and a shorter one thanks...

Yes Chulett I did. I tried using IsValid() function but in vain. Correct me if I am wrong. If I have a char value as Str="devi1" then this is a valid char value. My requirement is to check if a char field has atleast one numeric value in it. If I say IsValid(StringToDecimal(Str),"Deci...

I have found a way to check if the field has a numeric character in it.

For example of Str='fare3d'
then we can use the count function
if count(Str,'3')>0 Then 1 Else 0
The above condition could be extended for all the numeric numbers 1,2,3,4,5,6,7,8,9,0

But is there another way out.

Hi All,

I have a small query. I have a varchar field of length 40. Need to check if any character in that field is numeric. Is there a function to do this in a transformer stage.
....:(

Thanks

Hi All,

could not find a solution to this problem. Is it that the parallel jobs are more stringent about the data formats that are received when reading that data?

thanks for the reply. That could be the reason. I tried reading the file in another project it worked fine. I have another issue with the same file. The file has 1000 records which are being read with a server job with pipe delimited, quote char as double, default padding as # and missing column act...

Hi, I am trying to read data from a sequential file stage and get the following error... any idea why.. Error Calling subroutine DSD.Browse (Action=5 ); check DataStage is correctly set up in the project EDQS_PROTO We have many server jobs created in this project already. Saw a similar post on this ...

Hi Ray,

I am not a premium member so unable to read the complete reply of yours

Thanks

Yes you can use a aggregator stage with Cus_code as the group key.

Hi All, I have a doubt here on the logical processing nodes defined in the configuration file need to get it clarified. Lets consider we have a single CPU and memory and the config file has 2 processing nodes. So if my job runs on 2 node config file there would be 2 process that would run in paralle...

Hi All, I have an small job which using a buildop in it which replaces the non-graphical characters in the input file to spaces. I have 10 records as an input from a sequential file and have character columns as input which are nullable. The job runs successfully but I receive warnings as follows: O...

Hi Ray,

Thanks for the reply..

I have mentioned just a few columns I have all together around 30 columns that I would have to entry manually.

Is there any other way out... to get them imported...