DSXchange

assuming you want to read the output of the command , you can do this using external soruce stage, place the command in stage and define the table definition

read all fields from fixed width file as char and then convert into requried datatype using trasformer or modify stage. your problem should be resolved

what aggregation method you are using in aggregate stage

in sparse lookup , you dont need to drag a key from input to reference link, just you need to have same cloumn name in both input links .

I am using windows xp sp3 - I installed both datastage server and client on same machine. i was using it for 2 year didn' have any issue. but today i had to uninstalled it and was trying to re-install it. I had looked into searched post , didnt get any much help. Thanks in Advance for your response

Hi I have installed datastage 7.5x2 on windows enviorment. I am getting below error message while running simple parallel job just after installaton. can any one please help me to understand below error. node_node1: Fatal Error: broadcastStepIR: socketpair(AF_UNIX, SOCK_STREAM, 0, socketArray) faile...

alwasy better to go to datastage help. Press F1 key and go to DS help, is the best repositery to understand transformation function. PadString(%string%,%padstring%,%padlength%) PadString returns the string padded with the optional pad character and optional length you need to provide the char to pad...

add neviorment variable $APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS and mark it to YES

which will reject the input records from sequential stage if any field value length exceed to defined varchar.

in one project you can both server and parallel jobs. people uses both type of canvas to develop jobs based on their requirements. in sequencer you can call both types of job along with other actvities.

for handle null use NullToValue and define high date like 9999-12-31 to date in case null. also validate the incoming string whether it is really coming in format you mentioned %mm-%dd-%yyyy.

As Ray suggested , please be clear when you post your problem. I believe you can assign a dummy value(like 'X' should be unique and different from your location id available in reference link) to input key in case of null. do the same with your reference link data )assign 'X' to location id which is...

as suggested in earlier post. you can use index function to search for string and write it into sequential file in job1. Then write a datastage server routine which accept file path and name and return you the value stored in file. in job sequence use user variable activity add valriable and call da...

when you select "entire partition" it basically copy all records to number of nodes defined in node configuration file.

for more details you go through Advance parallel job developer guide

I believe , when you add reject link to sequential stage, you cann't handle null as it takes entire record as a single field "Rejected" (var binary notnull) you dont need to handle null here.

let me know if that is not a case

if you choose sort and merge collection method in target sequential file , you could have achive your desired output.