DSXchange

If my date is 03-JAN-07 and I'd like to format it to be YYYY-MMM-DD, is there a way in Datastage for it to automatically put "20" in front of "07" for the year? My current workaround for this is I do an if-then-else derivation similar to the following: If datevar[8,2] > 50 then '...

Before we do that, do you understand C/C++ syntax at all? And have you read the chapter on programming within parallel jobs? Please post the pre-loop code (where, for example, the variable called holdkey is initialized). Please ask more specific questions. Basically this is what we wanted to achiev...

Hi, We have a buildop to do the following: It gets the unique 2-byte values from the string field with the same key. Example Input: rec# key string (20 byte value) 1 KEY1 aa 2 KEY1 abaa . . 10000 KEY1 xxaaab 10001 KEY2 yy Expected Output: KEY1 aaabxx KEY2 yy Current logic in the buildop: if (KEY_IN ...

I finally got the answer.
What I did not realize that in UNIX you need to navigate back to root in order to locate a different directory other than the home it lands.

ftp://hostname/../../mypath/file.dat

ArndW,
Will give it a try. I will let you know.

Thanks -
johna

ray.wurlod I did as you suggested and got the following: FTP_Enterprise_X: uri is having invalid syntax. uri : 123.4.56.789/mypath/file.dat Documentation (FTP Enterprise Stage User Guide) seems to indicate that the ftp:// prefix needs to be there, unless I am reading it incorrectly :?: . regards- jo...

I am attempting to pull a file from HP Unix Box to DS Linux Box. Has anyone come across this error while using FTP Enterprise Stage. FTP_Enterprise_X: uri : ftp://123.4.567.89/mypath/file.dat is not valid remote file I can sign into linux and ftp IP using get the file with no issue. I have scanned t...

DSguru2B,
Thanks - I will try this option and keep you appraised.

Thanks again.
John

DSguru2B,
What stage would I use then? Would I use a C routine as someone previously suggested?

Regards -
John

Hi Arndw and DSguru2B, I understand your concept and I have done something very similar. I am looking for a Parallel solution but I will definitely keep this in mind. I do not know the other person who posted under UPS. I am the original one who posted as UPS. Thanks for your help. John - jalden@ups...

Hi Arndw You will know the key changed only when you read the row where the key changed so ideally rec1: key1, fld1 rec2: key1, fld1 rec3: key1, fld1 rec4: key2, fld1 rec5: key2, fld1 Only when i read in rec4 Key2,fld1 i will know the key has changed so if you want me to write out what i have been h...

Newbie question :?: - Can anybody tell me how to accomplish what the PIVOT stage does but in reverse. Input: rec1: key1, fld1 rec2: key1, fld1 rec3: key1, fld1 rec4: key2, fld1 rec5: key2, fld1 ... OutPut: rec1: key1,rec1.fld1,rec2.fld1,rec3.fld1 rec2: key2,rec4.fld1,rec5.fld1,, ... The process shou...

We are getting the following warning message during our load:

"Implicit conversion from source type "dfloat" to result type "decimal[18,2]": Possible range/precision limitation."

The source definition is a 'double' and the target is NUMBER(18,2).

Any suggestions?

Thanks Ray. So with the default file type of 1 is this an unsafe operation? I really don't understand the implications of changing the file type to 19. I have many projects and since I will need to keep &PH& clean on all of them I would have to go and change them all. WHat is the downside to...

I am trying to create a basic program that will purge this &PH& directory of all files older than a certain date. Support gave me a template basic program to work with but I am having trouble getting it going. In one post Ray.wurlord says he uses a unix find command to clean out the director...