DSXchange

No, in order to use the SQL DML you need a DICTtionary. But that does not mean that each file has to have it's own DICTionary file, you can point the VOC entry to a common DICTionary file if you wish. When using a hashed file using SQL type commands there are 3 things that need to be in place, a VOC...

Your funnel expects to match columns with the same name and output them. In this case, those two columns are not present in both (or all) inputs.

The error is probably nothing to do with NLS, but just as the message states you most likely have more data in one or more columns of some rows that cannot fit into the target datatype. This is assuming you don't have datetime columns. Have you checked the metadata in both the job and also in the ta...

I don't know about V8, but at 7 there is no automated way of doing that directly that I can think of. But you can get at this information using the builtin routines; one of the returned values of DSGetJobInfo() is the parent job - which would be the calling job sequence. So if you looped through all...

vsi, would it be possible to reformulate your question? I gather you are referring to tasks that need to be done either by the people creating the data source or the people who are loading this data to databases - but I don't quite understand what you are looking for.

Would the UNIX "crypt" command do what you are looking for?

There is something wrong with your derivation. The TRIM() function should only have one argument in your example, you have misplaced a close-parenthesis.

You could also add code to check if "DCOUNT(Lnk_Read_PHONE.PHONE_EFF_DATE,'-')#2 THEN 0"

Null values tend not to come from sequential files, but you can specify your column metadata to get null values. I don't see why a lookup on a null column should be rejected, it is a valid lookup -- unless you have specified that the columns are not nullable in the source or the lookup.

What the responders have alluded to, but not stated explicitly, is that a sequential cannot be read from and written to at the same time. This has nothing at all to do with DataStage but is an inherent limitation of the sequential file type on all operating systems. So the suggestions all try to wor...

Sure you can use OR - "NULL() or value =0" is the inversion of the condition. Yes, you can do the null to zero - that will solve your null dropped record issue.

What about the mkdir - can you do that?

...IsNotNull(Read_Lnk.P_MKT) And Read_Lnk.P_MKT <> 0 ... An "AND" condition will always evaluate both sides, so this will drop records with null values of Read_Lnk.P_MKT. You need to change your command to either an OR statement checking for nulls first or add a handle_null to convert the null to a...

What does "ls applis/psoft/FSCM4_APPL/CBLKOM/Datastage/Projects/ FDM84_90_CBLKOM/KOMODO/LOOKUP/HF_TEST" and/or "touch applis/psoft/FSCM4_APPL/CBLKOM/Datastage/Projects/ FDM84_90_CBLKOM/KOMODO/LOOKUP/HF_TEST" return (remember to delete the file after the touch. Actually, instead of touch it really sh...

They must have been very short and right after each other, I think the internal clock is either 30 seconds or a minute. This is to prevent double-clicking on the submit button and getting 2 or more submissions of the same post. Also to prevent DOS attacks.

Raj,

you've probably seen that the DS scheduler interface doesn't support that. On Windows DataStage will use the AT command, and if you look at the help there the syntax might help you further.