DSXchange

Sure the first line is column names, but how does DataStage know how many columns and how wide each column is? You're going to have to type in each column name and set the width. Or, switch to a delimited file.

I personally don't like environment variables because when developing the jobs the "View Data" capability is severely limited. You can use defaults embedded in the job. It just makes life more difficult. It's a good thing if you're not using hardcoded values for things like credentials and paths, bu...

splayer wrote:ray, how do you set DRS to use the native API?

By choosing Oracle, DB2, Sybase, etc.

If you intention is an UNION ALL type result of links, the Funnel is the stage you use. If you're joining, consider the Join, Merge, or Lookup stages.

What is the purpose of the Transformer stage? Can you add a Sequential output and verify the results are correct?

Try putting eval in front of the command line for dsjob. In some environments weird things happen, this seems to fix it. eval /opt/dsadm/Ascential/DataStage/DSEngine/bin/dsjob \ -server $Server \ -user $User \ -password $Pwd \ -run \ -param WorkDir=$WorkDir \ -param FileDate=$FileTS \ -param var1=$n...

You create the load file on your PX Unix server. Then, FTP to the SQL-Server machine and use ssh or remsh to kick off a remote bulk load execution.

If you mean replace everything in front of the first "-" with something else. I think you have a few choices. One is using the FIELD function. The other is to use the INDEX function and substring notation. Write a DS Function and test both of these: Ans="XYZ":"-":FIELD(Arg1,&...

I don't think your syntax for getopts is correct. You can verify this by echo'ing $0, $1, $2, $3 to see command line arguments passed. You'll see that your command line contains the date.

What's the EXACT command line string you are passing?

REMSH, RSH, RLOGIN, SSH, SCP. Check out these commands, as they are available on both Windoze and Unix implementations. You can remote shell login to a server, run a command locally on that machine, and then exit. For secured environments, SSH and SCP are what you could use. For SSH and SCP, you can...

resource disks are used in the order listed, that's why you could consider configuring several file systems and listing them in a shuffling order as you progress thru the nodes. So, if you have 6 nodes and 6 file systems, list them in order 1-6 on node 1, 2-6 then 1 on node 2, 3-6 then 1-2 on node 3...

If the hashed file is externally pathed, you'll need to write a function to open the file and count the records or use the SETFILE command to created a pointer to it and then use kris007's method. If the hashed file is in the project, you can use kris007's method. To read the hashed file, you'll wri...

Set up the ODBC connection, make sure you use a hostname and not an IP if your SQL-Server is on a DHCP assigned machine. Also, you need the port number as well, very important.

Scurry off Craig. Take your almost 7000 posts on this site and crawl back into your hole. You and the rest of the so-called "Premium Posters" don't rule here. Beat it, and don't let the door swing back and crack you where God split you. Your mother was a hamster, and your father smelt of elderberrie...