DSXchange

Hello brunix,

you probably have column propagation turned on for that link.

krsriraman ,

I am sure that you would already have received answers, had you not specified URGENT twice in your e-mail.

While you are awaiting answers, perhaps you could use the search functionality on this site to see some answers.

deepthi: I guess I am at a loss - I see a valid error message saying that a format has been broken and you are saying that even though you intentionally changed the format it should work (and does work in other jobs). But I am sure that someone else in this forum can assist you; I still think that r...

Keep the correct metadata; if you are doing a view-data it will pad with zeroes, but if you write to a file you will see that there are no leading zeroes. You can also use explicit conversions or formatting, but I think that your error message from DS is correct from the program's point of view.

deepthi,

right at the beginning you have the error message excerpt

Fatal Error: APT_Decimal::assignFromString: invalid format for the source string.

So, you have a string coming in that you are implicitly or explicitly converting to a decimal. Does this not narrow down your problem?

Mahesh, a core file can give detailed information on why a program aborted. The two programs I listed can be used to analyze core files; but they are quite complex and since you haven't used them before I wouldn't recommend starting now. Either your Administrator knows how to analyze them or not. Bu...

Nripendra,

I think that the view-data is correct; if you look at the log file it will say that it found no rows to display (I just tested that).

I don't know if using an empty dataset/table/file is legal as a reference; that might just be a product restriction and not a bug.

Phanee,

do 2 things:

1. open up a call at Ascential stating that the DSINCLUDE JOBCONTROL.H is missing the line "DEFFUN DSGetStageLinks(JOB.NAME, STAGE.NAME, LINKMODE)"

2. add that line to your job.

XP Professional or Home edition? Is the process hang in the Designer? Are the client and the server on the same machine?

I guess you have hit a restriction in the view data, since you don't get an error when looking at the dataset metadata from the tool management it must exist. What is the exact error message you are getting?

The free method of doing comparisons is to use SOUNDEX - but it is not particularly smart. If you want very good name and address matching and cleansing algorithms there are packages out there (Vality comes to mind) that are very pricey but do a wonderful job. I think that doing a MCN conversion (ev...

go into UNIX and attach to the directory where you .ds dataset descriptor file is located. Execute "orchadmin ll <yourDataSetName>". Any errors should be clear, otherwise you will get a lot of information telling you that you have 0 rows. Oh, I just recalled you can do the same from the Manager and ...

There are 4 sets of numbers between 0 and 255 in an IP address. Assuming your start address uses the top 2 groups: StartIPClassA = 64 StartIPClassB = 23 AddressesToGenerate = 8000000 AddressString = '' ;** this is going to be a big string! IPA = StartIPClassA IPB = StartIPClassB IPC = 0 IPD = 0 FOR ...

Mahesh,

is the core file generated from the compiler or from DataStage? (you can use dbx or mdb or get your System Administrator to tell you). There is little Ascential can do if it is the compiler coring out.

Kumar, I am still unsure about what you are doing, but that is beside the point. DataStage PX has the functionality of allowing you to deprecate or even remove certain types of messages from the log files. So, even though I don't feel truly comfortable about you doing this, you can read up on the "m...