DSXchange

Hi, You can do that in Datastage Manager. It is given in the Datastage Documentation that,we cannot use Unix cp or rm commands to copy or delete a dataset becuse,Datastage represents a single data set with multiple files.Using rm simply removes the descriptor file,leaving the much larger files behi...

saadmirza - in DS you can explicitly set the output file format in the output CSV file, I guess this is what you are doing as you say you can view the data. What is your input database and what are your NLS settings for that source stage?

The file-viewer in Datastage is most likely converting the character to a "?", where are you displaying this from - and if you are using a database utility, make sure that it's display attributes set via the environment variables are set correctly (see if other tables show German characters correctl...

I've got to side with Wolfgang here. The only German character that can conflict (when not using NLS) is the u-umlaut as that maps to either a @VM or @FM (cannot recall which one). If you are doing explicit mapping from one character set to another then the most likely error you are going to get is ...

Wolfgang - great approach for Server! That's like Christmas, I will give that a try later on. {rubbing hands together in anticipation}

Jusami25, Unfortunately this is not possible in Server, and in Px it is possible to use implicit columns but perhaps not to the extent that you wish. Since an ETL process usually processes columns in addition to reading/writing them this type of job design is not too common. Are you reading and writ...

Craig - I see what you mean about question number two, I just looked at the question (along with the others) from another angle. At first I thought I would be tongue-in-cheek (hash files are, from time to time, refreshed by the blood of overworked consultants) but then decided a terse answer would s...

Hello Rajima, (1) .how to refresh the hased files? Since your DataStage jobs read from and write to Hashed files you take care of refreshing their contents yourself. They are no different in that aspect than other database tables. (2) which will execute first routine or transform? Neither - you have...

Andal,

if you have a list of files then you can use the loop construct within a sequence job and iterate through the list call up your counting job for each Hash file object.

Hello Andal,

there probably is, but you need to add the selection of the category to your query. How do you differentiate your "Categories"? Is it by location? By file name?

PilotBaha - I just installed the 7.5.1 upgrade 30 minutes ago and still have the CD in the drive here at work. Fire off a private message with your e-mail address and consider the document on it's way.

Perwez, There are so many formats out there that say they are a "Julian Date". A common one is the number of days since Noon (12:00), 4713 January 1 B.C. The DataStage server form of the Julian Date is an integer number stating the number of days since 1967-12-31. So the first thing that you need to...

It looks like the table (UniVerse file) is declared differently in each environment. Use the Manager to read in the column descriptions in both environment and compare them.

Perwez, in DataStage server there are 2 commonly used conversion functions, ICONV() and OCONV() (input- and output conver respectively). If you do a search on either of these along with the keyword "date" you will get many, many threads that address your question. And if you add the term "julian" yo...

Sathyanveshi, the only thing controlling on which CPUs processes get executed on is the OS - DataStage has no control on where a specific orchestrate pid gets thrown. So in your case with a 4-node configuration file and 8 cpus you cannot assume that a node will go to 2 cpus. But nonetheless the proc...