DSXchange

Hi Ravi, Schema file is used to pass the metadata to a job/ stage and not the data. The schema file should contain the metadata ex. field names, data types and length. The definition of a schema will be something like this record( Field1:String[10]{delim=none}; Field2:String[10]{delim=none}; )

Hi,
I have added CcAddress to the arguments of DSSendMailTester routine and changed the code accordingly..but DSSendMail(which will be called from DSSendMailTester) is not accepting it.
Please test it from your end.. I might be wrong some where..

Hi Sajid,
You can use comma(",") after the first email-id and add another id to that in "To" itself. There is no CC option available.

i had a look at the DS documentation but couldnt find any information. pls let me know of anyworkaround. Hi Rajesh, From the documentation You can include comments in schema definition files. A comment is started by a double slash //, and ended by a newline. The following examples show various diff...

CT ID is the Keycolumn for the Joiner J_29 and all stages i have specified CT ID as Non Nullable. Even it gives a type conversion warning as below. Join_29: When checking operator: On input data set 1: When binding input interface field "CT_ID" to field "CT_ID": Converting a nul...

You can use DSJobStartTimestamp instead of CurrentTimestamp(), it's there in DS Macro.

Hi Rajendhar,
Add some parameter (say INVOCATION_ID) to the job parameters of the Job Sequence. Go to the required job activity stage and browse for Invocation Id, there you will be able to find all the job parameters. Select the required one (INVOCATION_ID).

[quote="adi_2_chaos"]Hi, You may try the following derivation: If (DSLink2.ID1 eq DSLink2.ID2) Then DSLink2.ID1 Else DSLink2.ID1 : DSLink2.ID2. Hi adi_2_chaos, What is eq in If (DSLink2.ID1 eq DSLink2.ID2) Shalini, Use If (trim(col1)= trim(col2)) Then (col1) Else (col1:col2) directly as de...

i can get uniq nos not a problem. but when multiple jobs run at the same time all will query the database and get the max(col)+1 value, which will be same and when they calculate unique values, all will have the same values and cannot insert if it is a primary key for the output table. You need to ...

Replace the nulls in 'POLINEAMOUNT' field with some value (Do the null handling)..

swathi Singamareddygari wrote: i tried using NULLToValue function also for assigning '' to date field but its not assigning empty to date field.
Swathi S

Try to pass all 0(zero) s into the date field in the correct date format which is used in you job,if the date field contains a null..

At which stage the records are getting dropped?Any warings(or information) from the job log?

Hi..
Try using the LongVarChar datatype in the datastage job..We are using LongVarChar[4000] to read some CLOB type data in our project..

Hi,
Search the forum with the key "add months"..

Hi,
Add the property "RemoteServer" under Connection and pass database name into that..