DSXchange

Hi mick How would you take 4 months from the date 20/01/06 (ie: return a date of 20/09/05). You cannot simply substract 4 months from the given date always. Because value "30/06/05 " will give you 30/02/05 which is not a valid date. You have to consider day part as well for the above value...

Hi

Line Termination : CR/LF is for DOS for UNIX you should use
[LF] (Unix Style Termination) option inside FTP stage.

Thanks

Hi Praveen Is there any way in Teradata Enterpeise stage to update records of a table. I mean can we write an update query in Teradata Enterprise Stage.. I can find a Write mode but not Write method. If Teradata Enterprise Stage does not support Update, Is there any other stage that can be used for ...

Vinay You can use both Teradata Entreprise Stage and Teradat Multiload stage to read data from Teradata. Enterprise stage uses normal sql command to select records from table whereas Multiload uses Fast export which is faster than enterprise stage. Both can be used to read data depends on volume you...

Champa Explain the logic of how do you get this result. The logic is not mentioned clearly in your question The output file should be as below. Codec_Descriptor_ID=1|Codec_Descriptor_Value=711 Codec_Descriptor_ID=2|Codec_Descriptor_Value=726 Codec_Descriptor_ID=3|Codec_Descriptor_Value=729a Codec_De...

Hi

I think that '06TGT' & '0625TGT' is not constant. A good approach is to read file sequentially and assign stage variable to identify the pattern of the the header record. Send data to link 1 unless you dedect a new header patter which will send output to Link 2.

This should help you.

Suneel

As Balaji mentioned you can use Ereplace function to replace space.

Syntax:
Ereplace(InputValue,' ','')

Example
Ereplace('suneel reddi',' ','')

Result : suneelreddi


Regards

Kris

I wanted to make sure that you received the first notification thro email.

"Reset if required and Run" is the one you need to watch. You will be fine once it is set.

Somu You cannot update a key column which is in SET and in WHERE clause. Having said that it is possible to do an update without key column eg. " UPDATE #tgtschema#.ABC SET IND=?,TS=?,DATBI=? WHERE CUSTTYPE=? AND CHOPT=? " But you have to make sure that each row you update will not violate...

Please ignore this guy. We all know what value you add to this community and how commited you are...Keep going Ray...We all want to see you hitting 100,000 Mark.....

Somu

Under the stage plug-in General tab you have update action drop down box which list all the option available for you to choose. Read manual for detailed description of each option.

Murali I don't think that there is a setting to abort jobs in case of referential integrity violation. You have implement this logic in your job by doing a lookup to the parent table to find out whether record exist and then insert. You can then take necessary action whether to make the job abort or...

Kris

Did you got any emails when the Sequence aborted first.?

Reddy

Your format is not correct that's the reason you are getting this error.

Attempt to convert String value "15-MAR-06" to Timestamp type unsuccessful

Use to_date(J1.JC_COST_DATE,'DD-MON-YY') that should work

You can use your datastage adminstrator to run your command.

SELECT * FROM DS_RESENU

Under the project tab click the command button. Inside you can run your query.