DSXchange

Hi all, Got few doubts What are the differences between a) KeyMgtGetNextValue -> Generates Sequential numbers b) KeyMgtGetNextValueConcurrent-> whats the meaning of concurrent environment. c)KeyMgtGetMaxKey-> help in datastage informs to use ODBC stage for this, can we use other stages as well? and ...

Doing a bit of indenting. Ray pls try to help ---------------------------------------- Tif Ident SP (key) Ident label Tif Data Area CONS-TRANS-DOC 00*HEADER *HEADER CONS-TRANS-DOC 00AAA AAA POSTED-REACT WRD CONS-TRANS-DOC 00ABA ABA ARRS-BD ADJ 4/88 CONS-TRANS-DOC 00ADJ ADJ ADJ LOAN BAL CONS-TRANS-DO...

i dont know where this question fits. Sorry to post it over here, if i posted it wrongly. i need to find out the column names from cobol copy book from a spreadsheet.. can you help me how to find out that.. I need to prepare the column list from the spread sheet. few samples from spread sheet. Tif I...

Hi all,

What are batch files? How do we create them?

Sorry ArndW for not putting my question right way. Thanks Kcbland.

Kcbland, could you please list out shell commands, which will be needed in designing datastage jobs and when will they be appropriate?

Can anyone explain, when do we need to do scripting for datastage (in which language)? why?

PS: just know few commands of unix

One doubt regarding this. Can we do it this way as well? a) Open the job where u r reading from ftp b) click job properties c) Select DSWaitForFile in Before subroutine. d) specify the server path Note : I have not used ftp, so far, but guess the above procedure works same way as for sequential files.

Hi All, DSGuru, to be honest, didnt understand what you have suggested. As per Kcbland, i have to get premium content soon. My basic question is, Is trigger good or writing that logic in state variable and adding to the derivation column of the target. Why and How, pls compare with how the logic dea...

Hi all, I have two tables namely a) emp b) emp_chg (emp contains the history data and emp_chg contains new data). Now i need to compare both these tables and load data back in 'emp', with a flag being set if at all there has been update to any column or any new record has been inserted. I have done ...

Thanks a lot for the reply

thank you

thank you

merge as well acts to perform join (correct me if i am wrong). I got from the manual when to use join and lookup. But if merge can be used ideally, lets say most of the sources. Then which to prefer?

Thanks for response & and ur patience

:D nah i too agree that the manual is right, say a given condition, how do i measure the physical memory?

what about the merge stage? should it be used when v r using datasets and should others not be used in this context?

do v need to use datasets as intermediate stages, before they r stored given to unix server as sequential file?