DSXchange

I am having problems deleting a hashfile. Here is my line: StrCommand = "del /Q " : pTEMPDIR : "\" : pHashFile : " " : Homedir : " " : HashPath : ' 30 1 4 20 50 80 1628' It deletes the DATA.30 and OVER.30 file but it does not delete the hidden .Type30 file. :?...

Ross, Thank you for your code!!......This sounds what I need.....!! :D :oops: Sorry for taking a long time to contact you but I was directed into another project and just now I am able to work on this one. I have a couple questions for your, pardon for my ignorance but I am new with Ascential and my...

Okay, looks like loading a sequential file into a hashed file is not such a good idea.....
Can I load it into an Access Database?
Doesn't Ascential provide a way to store tables from within itself?
(Pardon my ignorance if I don't know what I am talking about Ascential)
Emilio

Thank you for the feedback :D , this gives me a good start. As far as loading the main sequential file into a table; does Ascential have a way to store its own tables (I thought that was metadata all about). Or could you do it into an Microsoft Access table? How about a Hashed file? which way would ...

Hello, :) How can I update certain columns in a sequential file with data from another sequential file. For example, the main sequential file would look something like this: LoanNo, ZipCo, State, Int, Sfee, balance 456124, 21788, PA, 7.1250, .0250, 75000.00 333120, 55151, CA, 6.7580, .0250, 99000.00...

I am in the windows enviroment but I was able to do it using the following contraint. Perhaps someone have a better way to do it: trim(NullToEmpty(xfmMissCode1.ArmConvOpt)) <> "" OR trim(NullToEmpty(xfmMissCode1.ArmIndexCode)) <> "" OR trim(NullToEmpty(xfmMissCode1.ArmNegAmrFlag)...

Thank You,
Should I check each field for null or is it possible to check if the entire row is empty?

Hello,
I have a sequential file that is showing empty but is really not empty, the file shows having empty rows like this:
,,,,,,,,,,
,,,,,,,,,,
for one or more rows.
How can I reject a row if is empty?
Thanks,
Emilio

Naveen,
When creating a hash file (I am a little familiar with this process), from the transformer I create the hash file and from the hash file, can I go back to another transformer or to a file?
Also, do I need to make all my columns key for the hash file?
Thanks

There are 10 columns and probably about 10 to 100 rows....
Emilio

The sample did no come up too well:
Here is a comma delimited one:
ArmConvOpt, ArmIndexCode, ArmNegAmrFlag
NONE, 100,
NONE, 200,
NONE, 100,
NONE,,AUCTION
NONE,,AUCTION

Needs to look like this:
ArmConvOpt, ArmIndexCode, ArmNegAmrFlag
NONE, 100, AUCTION
,200,

Mike here is a better 3 column sample: ArmConvOpt ArmIndexCode ArmNegAmrFlag NONE 100 NONE 200 NONE 100 NONE AUCTION NONE AUCTION Needs to look like this: ArmConvOpt ArmIndexCode ArmNegAmrFlag NONE 100 AUCTION 200 I hope this makes more sense...

Thank you for your replies: I have some questions: Naveen: 1) I was trying the aggregator to do the count >1. Where do you enter the >1 criteria in the aggregator? :? 2) How do you use the stage variables? explain this a little more. Mile: If this does not work I would like to try the hush file meth...

Hello, How can I get rid of duplicates on columns using datastage? :?: My file looks like this: ArmConvOpt,ArmIndexCode,ArmNegAmrFlag,ArmRoundFlag,BorrSelfEmpFlag,BorrSex,CoBorrSex,DocumentCode,DwellTypeCode,LimitDocFlag NONE,100,,N/A,,,,,AUCTION,WHO KNOWS NONE,100,,N/A,,,,,AUCTION,0 NONE,0,,N/A,,,,...

Hello! I am fa :) irly new to Ascential DataStage and I have some questions to some of you that are more experienced: From a routine I need to write into a file. For example if a code "60Delnq" in a field named "DELINQ60" has not match in Hashfile1, and "code "ALT"...