DSXchange

Hi, Using the user-defined sql in Teradata API, and the oprtion {FILE} (file path) instead of typing the SQL script directly into the user-defined sql tab in Teradata, would it be possible to parameterize the table path in sql script itself? For example, I want to execute {FILE} /root/aaa.sql In the...

Thank you.Its already working. I noticed my mistake

Hi, Please how will I solve such a scenario? I have a column A: 23434 45235 AB234 13443 12444 AB324 13443 AB324 12334 I want such an output 23434 1 45235 2 AB234 3 13443 3 AB324 4 13443 4 AB324 5 12334 5 Basically if column A[1,2]="AB" the number remains the same. I defined sth like this i...

Hi, I want to express LIKE or NOT LIKE in DataStage. For example I have an SQL statement like this: select * from Y where X like 'Chels%' select * from Y where X like '%Arsen%' select * from Y where X not like '%ManU%' How will this be represented in DS? I thought of using MATCH(es)... I want the wh...

Hi All,
Can someone please tell me where to get a good documentation on this?

Regards
Kay

You are right. Thanks. I tried it, but preferred the RowProcCompareWithPreviousValue.

Thanks a lot

Thank Sunshine, it worked. YOu make everything look easy. Hopefully I will get to ur level soon )

Assuming I have an input: 1234 1234 3435 1253 3455 3534 I want some specific no to be assigned to another column if the rows are the same. In the case above, a number 1 is assigned in new col to 1234 but once it changes to 3435, it changes to 2. I tried this : current: DS.Colname previous: DS.Colnam...

Hi Sunshine, This question is not about the previous one.I solved the previous one already. The NO is the hash file is newly created. I need that hash file so as to confirm if the orderNO(Y345 etc) is not in the hash file. I have only NO in the hash file. If the NO from the source is not present in ...

Hi Sunshine, I have an input file In the input file I have this: ID NO AMT 0000 Y345 7 0000 Y346 5 0001 Y322 4 0001 Y341 6 0002 Y345 6 0002 Y234 2 etc In the Hashfile I have this: Y345 Y341 0002 etc the order(for example 0000 Y345 7) is rejected if the NO(Y345) is in the HASHFILE. Not only is the or...

One more thing pls
ID NO AMT
0000 Y345 7
0000 Y346 5

0001 Y322 4
0001 Y341 6

0002 Y345 6
0002 Y234 2
Above is the input(d same) and I need to have this a database, but if for example Y345 is not a hashfile(NO), then the whole order by the customer is rejected, even Y346.
Thank u

Hi Sunshine,
Perfect idea. It worked perfectly. Thanks a lot.
Kenny thanks too. Your idea also worked. I tried both.

Thanks Kenny for your time. I will try your idea now.

Thanks

how would the stage var look like?sorry for the questions...still new to it

For the INROWNUM, it means that in each of the output file, I should add a new column for the INROWNUM?If Im right..In that case I would expect the first group 0000 to have one and then the respective cols 2 and 3 for this example. Whjat aboiut if the group increases to 2 in the ssecond row in the g...