DSXchange

That's because you are re-opening the file (and thus positioning to beginning of file) within the loop. Open the file before you start the loop and don't forget to close the file (which releases th ... I do not have rights to view the Premium content. It would be really kind if you post the same as...

Hi!! I have a source feed in the following pattern: INFILE ============ COL1,COL2,COL3,COL4,COL5 987,2,3~7~5,400~468~598,0005~4687~5980 1111,2,2~7,400~468,0005~897 The file is mainly delimited by comma(,). Further in COL3,4&5 it has subdelimiter as tilde(~) Further within COL3,4 &5 no of ~ m...

I thought I could do that once as well, but the column generator doesn't work that way, so I ended up reverted to using a transform stage in PX and getting the system date and time "the olde way". ... If I use datatype as date then in generator there is an option of "Use Current Date...

HI, In my server job ,using transformer stage I used to derive the system date by using @DATE & @TIME system variables. In my parallel job,I want to do the same using column generator (i.e. without using transformer stage). I need to set the default value of the generated column to sysdate. Is t...

I got the solution. Instead of using $ReturnValue, I used $CommandOutput Thanks for your help. Gateleys: The SQL is fine...thinks are running fine now... --dtatem dtatem, since your problem has been addressed, can you please mark the post as 'Resolved'? And, may be help our friend loe_ram13 with his...

Dear dtatem, I followed the steps specified below. In Output of Execute Command stage, I get two data: Reply=0 Output from command ====> xyz(this is the required data). My problem is how do i pass this output as specified in step 5 of the Quote?? Pls help. Thanks in advance Good Day: I have a server...

Dear dtatem, I followed the steps specified below. In Output of Execute Command stage, I get two data: Reply=0 Output from command ====> xyz(this is the required data). My problem is how do i pass this output as specified in step 5 of the Quote?? Pls help. Thanks in advance Good Day: I have a server...

Dear dtatem, I followed the steps specified below. In Output of Execute Command stage, I get two data: Reply=0 Output from command ====> xyz(this is the required data). My problem is how do i pass this output as specified in step 5 of the Quote?? Pls help. Thanks in advance Good Day: I have a server...

Dear dtatem, I followed the steps specified below. In Output of Execute Command stage, I get two data: Reply=0 Output from command ====> xyz(this is the required data). My problem is how do i pass this output as specified in step 5 of the Quote?? Pls help. Thanks in advance Good Day: I have a server...

Dear All, I have a monthly job that extracts data from table whose volume is very huge around 300 crore records totally & 60 columns. I have to extract 15 columns from that table and also have a group by clause in it to find the count of each person who has called more than 3 times. My present q...

Call the job from a sequence and pass the table name as parameter and pass this as parameter from the sequence : 'x_' : '2007-05-06'[3,2] : if RDATE[6,2] = '10' Then 'J' Else if RDATE[6,2] = '11' Then 'K' Else if RDATE[6,2] = '12' Then 'L' Else Ereplace(Convert("123456789", "ABCDEFGH...

Iconv() doesn't need the format but, if given, it must be right. You have omitted "A" for the month. Oconv(Iconv(ToT1.START_DATE,"D-DMY[2,A3,2]"),"D-YMD[ ...[/quote] My transformation logic is: Oconv(Iconv(ToT1.START_DATE,"D-DMY[2,A3,2]"),"D-DMY[2,2,4]")...

If you have all the dates stored in a file then use this code in batch datefile=filename with fullpath Openseq <datefile> to <tempfile> ReadSeq Rec from <tempfile> else eof=1 Loop Until eof ipdate=Field(Rec, "|", 1) 'call the job and pass ipdate as parameter to it' Repeat WEOFseq <tempfil...

what i get from ur question is that u want to create table based on the i/p values... What u have to do is to use some parameter say "ipdate" and pass it to target stage where you can have ur table creation query and ur query will look smthg like: Create table #ipdate# <column name> <col ...

ray.wurlod wrote:Beware of the terminology. It's hashed file, therefore it's hashed lookup.
The hashing algorithm used in lookup is the one that is specified for the hashed file. There are two choices ...

How are GENERAL & SEQ.NUM different??
Can u elaborate a little??
Thanks in advance...